PC Review


Reply
Thread Tools Rate Thread

2 Questions on Pivot Tables - 1 tip

 
 
av fan
Guest
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
chart?

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
England.


 
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
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


Features
 

Advertising
 

Newsgroups
 


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