Hi,
Seems like a simple thing to do but it seems to be eluding me. Hoping for a pointer at how to remedy it or a link to somewhere I can read about doing it.
I have a pivot small pivot table that has numbers in first column, 1, 2 and 3.
The data in the second column is grouped by those numbers so:
1 Data row 1 Total
Data row 2 Total
2 Data row 1 Total
Data row 2 Total
When I create a chart all the bars sit equal distance apart and are of the same colour. I am looking to have all bars that represent a value from group 1 grouped together and preferably with different colours for each data row. I misunderstood clustered column to mean that, each group clustered together for ease of identifying each groups data in the chart.
Thanks in advance for any pointers.
Seems like a simple thing to do but it seems to be eluding me. Hoping for a pointer at how to remedy it or a link to somewhere I can read about doing it.
I have a pivot small pivot table that has numbers in first column, 1, 2 and 3.
The data in the second column is grouped by those numbers so:
1 Data row 1 Total
Data row 2 Total
2 Data row 1 Total
Data row 2 Total
When I create a chart all the bars sit equal distance apart and are of the same colour. I am looking to have all bars that represent a value from group 1 grouped together and preferably with different colours for each data row. I misunderstood clustered column to mean that, each group clustered together for ease of identifying each groups data in the chart.
Thanks in advance for any pointers.