PC Review

Thread Tools Rate Thread

2 Questions on Pivot Tables - 1 tip

av fan
Posts: n/a
      25th Feb 2005
Any assistance appriciated. (Excel 2003)

1) I have a simple Pivot table showing 6 groups with their totals and a
subtotal eg:
America 10
UK 15
Oz 22 etc.
Grand Total 125

I want to Pivot Graph this data, no problems. I want however an extra line
to show the total on the Secondary Axis. I have almost got it by placing
the column in a second time as a Running Total and then as a Line on my
chart, hiding all the values until the last point.

However I would like if possible the Total as a horizontal line across the

2) I have come across Grouping Dates and the inability to Group if there
are blanks. I thaught about generating an invalid date eg 01/01/1900, to
use that and ignore it later, I thaught about sorting and inserting a row to
knock the blanks out of my pivot using a macro.....

Then a thaught, I tried linking the data into Access 2003 and writing a
Pivot Chart query and it worked. I am VERY happy to discover this, only a
simple questions, was it possible in Excel....?

Roger Knowles
MOS Master all Versions

Reply With Quote

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
Re: Gold tip VS. Silver Tip USB cables...? Grinder Computer Hardware 0 14th Sep 2008 06:40 AM
Re: Gold tip VS. Silver Tip USB cables...? Bob Smith Computer Hardware 0 14th Sep 2008 01:49 AM
Re: Gold tip VS. Silver Tip USB cables...? Kent_Diego Computer Hardware 0 13th Sep 2008 05:23 PM
How do I create a Tool Tip/Screen Tip in a table in Word? =?Utf-8?B?Q3ludGhpYQ==?= Microsoft Word Document Management 1 24th Oct 2005 09:25 PM
what is a screen tip and a button tip? =?Utf-8?B?amlt?= Microsoft Word Document Management 1 27th Sep 2005 09:25 PM




All times are GMT +1. The time now is 01:26 PM.