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 :-) 

[Andrey Khaneev _StiltSoft_ · Accepted solution]

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]

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.

[Tabea Wich]

okay thanks a lot for you help!