LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Doobi
 
Posts: n/a
Default How do I compare output data from 2 pivot tables in a graph forma.

I have a pivot table created for 2004 that shows the number of inspections we
received on a particular day of the week (ie. 5 on saturdays, 2 on
wednesdays, etc.) I am creating the same pivot table for 2005 and am looking
for a way to graph the data (bar graph) of the pivot table from 2004 to
compare with my 2005 data (ie. last year we received 5 inspections on
saturdays, this year we received xx amount on saturdays). Is this even
possible to do? I am using Office Pro 2003 and any suggestions would be
greatly accepted.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting data in Pivot Tables gramos14 Excel Discussion (Misc queries) 2 January 17th 05 11:07 PM
Pivot tables, external data sources and ODBC links plato Excel Worksheet Functions 0 January 17th 05 05:07 PM
Pivot Tables, can I use an external list to select data items? Brian Lofquist Excel Worksheet Functions 0 January 4th 05 06:43 PM
Pivot Tables referring to external data query Excel GuRu Excel Discussion (Misc queries) 4 December 29th 04 06:29 PM
Pivot Tables multiple data fields Excel GuRu Excel Worksheet Functions 2 December 16th 04 12:06 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"