Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Customise Chart (2K3)

    Maybe an easy one but I am scratching my head on this one.

    The image below depicts a chart which shows Date (column A), Daily values (column and 7 day accrual (column C). The last value in C are simple sums of 7 values in column B.

    I would like to create a chart such that the Blue values (from column are as you see and the Pink vlaues (from column C) are in the form of a bar chart. Any ideas?
    Jerry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Customise Chart (2K3)

    Click on the pink series to select it (you can also select it from the dropdown on the Chart toolbar).
    Make sure not to select a single data point.
    Select Chart | Chart Type...
    Click on the Column Chart type and click OK. It will be applied to the selected series only.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Customise Chart (2K3)

    Well knock me down with a feather <img src=/S/drop.gif border=0 alt=drop width=23 height=23>

    Was it that simple? Thank you
    Jerry

Posting Permissions

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