Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Canberra, Australia, Australian Capital Territory, Australia
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Colour Schemes for Graph Series (XL2k sr1)

    Is there someway to fix the symbols and colours for a series of graphs (eg when using pivot tables and changing data sets)
    MS doesn't seem to group the colours and symbols according to pivot table source so all row1 are blue and column 1 are triangles etc.
    I have to reset these every time I change the table data!
    Help please!

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Colour Schemes for Graph Series (XL2k sr1)

    All the usual functions appear to be available if you click the Chart Wizard on the Pivot Table toolbar, so the following should work.

    Click on the Chart Wizard button.
    Edit your chart the way you want it.
    With the chart selected go to the Chart menu and choose Chart Type.
    Select the Custom Types tab.
    Select User Defined, then Add.
    Give your chart a name. Press OK.
    Click Set as Default Chart.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •