Looking support to develop the stacked chart
Hi All,
I would like to develop the stacked chart for the below data. it was really hard to group under the same company names with different ageing.
This data i am pulling from the GRID - Report (Summary Report)
This is my required chart be?
Any leads could you please help me out?
Best Answer
-
Hi @RajKumar 28,
It sounds like you would like to build the below stacked column chart for all companies using the metrics in your Sheet Summary Report.
The Sheet Summary Report you've built will only pull into a Report as one row-per-sheet, preventing the chart to stack data.
As a possible way around, you may want to create a metric sheet similar to the one below to source your data:
After selecting the Metric sheet range above as the data source of your Chart Widget, you can use the following configuration to build the desired stacked column chart showing all companies or you can create individual ones by Company:
Note that you can use Cross sheet Reference formulas to build your metric sheet with the relevant data coming from the source sheet(s).
I hope this can help you achieving what you intend.
Cheers,
Julio
Answers
-
Hi @RajKumar 28,
It sounds like you would like to build the below stacked column chart for all companies using the metrics in your Sheet Summary Report.
The Sheet Summary Report you've built will only pull into a Report as one row-per-sheet, preventing the chart to stack data.
As a possible way around, you may want to create a metric sheet similar to the one below to source your data:
After selecting the Metric sheet range above as the data source of your Chart Widget, you can use the following configuration to build the desired stacked column chart showing all companies or you can create individual ones by Company:
Note that you can use Cross sheet Reference formulas to build your metric sheet with the relevant data coming from the source sheet(s).
I hope this can help you achieving what you intend.
Cheers,
Julio
-
Hi @Julio S.
Appreciate your help, i have created the cross reference sheet to pull metrics and created the stacked bar chart. Appreciate your idea and now i made it. thanks alot
Regards
Raj
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives