nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Chart Macro - use only select rows and change the order of columns

Tabea Wich

Dear community,

I have tables including revenue, operating profit and profitability with time periods reaching from right to left as common in annual reports. Now I want to create charts from that and as revenue and profitability can hardly be displayed in the same chart I want two charts one only using the row labelled revenue and one using the row labelled profitability. Additionally, I want the chart to use the columns other way around i.e. dates should reach from left to right as usual in charts.

Is this possible?

Thanks for you help in advance :-)

Accepted answers

Andrey Khaneev _StiltSoft_

Hello @Tabea Wich

If you could share a screenshot of table with data, it would easier to give you advice.

As I see Table Filter and Charts will be helpful in this case:

You can use Table filter macro to filter out revenue and profitability rows for each chart.
Table Excerpt and Table Excerpt Include macros will help you to avoid copying the table for each chart macro.
Not sure, but you may need to aggregate values for profitability and revenue with Pivot Table macro instead of filtering tables.
And you can use Chart from Table macro that is compatible with Table Filter and Pivot Table macros.

There is a demo site where you can play with the app to see if suits your needs. Also you can contact support for personal assistance.

All comments

Andrey Khaneev _StiltSoft_

Hello @Tabea Wich

If you could share a screenshot of table with data, it would easier to give you advice.

As I see Table Filter and Charts will be helpful in this case:

You can use Table filter macro to filter out revenue and profitability rows for each chart.
Table Excerpt and Table Excerpt Include macros will help you to avoid copying the table for each chart macro.
Not sure, but you may need to aggregate values for profitability and revenue with Pivot Table macro instead of filtering tables.
And you can use Chart from Table macro that is compatible with Table Filter and Pivot Table macros.

There is a demo site where you can play with the app to see if suits your needs. Also you can contact support for personal assistance.

Tabea Wich

Thanks a lot for you help! Unfortunately, my organization doesn't have these macros. I guess, there's no way to do it just with the regular chart macro?

Tabea Wich

tables with charts.JPG this is my table and the charts I want to create

Andrey Khaneev _StiltSoft_

I tried to do it with the Chart macro, but it looks like impossible to do.

Here what I got with Chart from Table macro:

The Chart from Table macro is a part of Table Filter and Charts app, you need to install it to get the macro.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

chart