![]() |
bar graph from pivot table with two data fields
I created a pivot table with two data fields (sum of income, sum of spent)
for each year. In the resulting pivot table, the year is displayed on leftmost column and then alternating rows for income and spent in the next two columns (one column text "Sum of ..", one column currency). Problem is that when I graph this, the bar graph shows all values but treats them as one category (and thus one color). I need the bar graph to show two colors, one for income by year, one for spent by year. -- Richard |
All times are GMT +1. The time now is 07:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com