ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   bar graph from pivot table with two data fields (https://www.excelbanter.com/excel-programming/402573-bar-graph-pivot-table-two-data-fields.html)

Richard

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