PC Review


Reply
Thread Tools Rate Thread

bar graph from pivot table with two data fields

 
 
Richard
Guest
Posts: n/a
 
      11th Dec 2007
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
subtract two data fields in pivot table Alok Microsoft Excel Charting 0 31st Oct 2009 08:50 PM
Filtering data from a pivot table to a graph Custard Tart Microsoft Excel Worksheet Functions 1 14th Aug 2009 02:23 PM
VBA Pivot Table help with data fields James Microsoft Excel Misc 3 13th Aug 2009 05:15 PM
Data Fields in Pivot Table MichaelR Microsoft Excel Programming 2 24th Jul 2008 07:07 PM
Data Fields in Pivot Table MichaelR Microsoft Excel Misc 0 22nd Jul 2008 06:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:03 AM.