Hi
Can someone please advise the best way to do this?
Perhaps someone already has a template
I have attached an example.
Thanks
Hi
Can someone please advise the best way to do this?
Perhaps someone already has a template
I have attached an example.
Thanks
There is way to do it, but it would be somewhat convoluted.
1. Select A2, B2, D2. Create column chart.
2. Select A2, C2, E2. Create column chart.
Copy 2nd chart. Select chart area of first chart and paste. Change chart type to stacked column.
Adjust data label as needed (Image below used Value from Cells concatenated with Value).
1.JPG
There may be a better method. But it eludes me.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Thank you for the advice.
The easiest procedure I know for a "clustered and stacked" column chart is this one: https://peltiertech.com/clustered-st...mn-bar-charts/ Note that most of the work is arranging the data in the spreadsheet. With the data properly arranged, the chart is a basic stacked column chart.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks