Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtracting two pivot table data fields | Charts and Charting in Excel | |||
VBA Pivot Table help with data fields | Excel Discussion (Misc queries) | |||
Data Fields in Pivot Table | Excel Discussion (Misc queries) | |||
data as a percetage of row fields in pivot table | Excel Discussion (Misc queries) | |||
Manipulating Pivot Table Data Fields | Charts and Charting in Excel |