2 Questions on Pivot Tables - 1 tip

Discussion in 'Microsoft Excel Discussion' started by av fan, Feb 25, 2005.

  1. av fan

    av fan Guest

    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.
     
    av fan, Feb 25, 2005
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bill L.

    need 1 more tip on xl timesheet..

    Bill L., Jan 30, 2004, in forum: Microsoft Excel Discussion
    Replies:
    0
    Views:
    258
    Bill L.
    Jan 30, 2004
  2. steveski

    Pivot Tables : Restrict data displayed in pivot table

    steveski, Feb 9, 2004, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    668
    steveski
    Feb 10, 2004
  3. NickDangr

    More requests for online references / looking for a tip?

    NickDangr, Feb 25, 2005, in forum: Microsoft Excel Discussion
    Replies:
    0
    Views:
    175
    NickDangr
    Feb 25, 2005
  4. Pivot table from multiple pivot tables

    , Feb 9, 2006, in forum: Microsoft Excel Discussion
    Replies:
    0
    Views:
    237
  5. Exiled
    Replies:
    1
    Views:
    407
    steven1001
    Aug 13, 2006
Loading...

Share This Page