+ Reply to Thread
Results 1 to 3 of 3

Two separate charts in one (4 sets of data)

  1. #1
    Registered User
    Join Date
    03-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    9

    Two separate charts in one (4 sets of data)

    EXAMPLE CHART.xlsx
    pricegraphwithvolume.jpg

    Hi
    I have 4 sets of data that have to go into one chart.

    - 2 sets are set out on the right vertical axis
    - 1 set is set out on the left vertical axis

    I would like the 4th set (V2x Index values) to show in a line chart underneath the x-axis as in the attached JPEG (please ignore the fact that it's a bar chart - it's about the idea of having a second chart running underneath across the same time schedule)

    ANyone have any ideas?

    THanks
    Eelko

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Two separate charts in one (4 sets of data)

    You would need to calculate new negative values for that extra series in order to get it to appear below the axis.

    You would then need to use additional series to fake the different parts of the value axis labels.
    You might find using 2 separate charts easier.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Two separate charts in one (4 sets of data)

    thanks for the quick response! very useful for a next project but i'm going to go as you suggested with two separate ones because it wouldn't work with the negative values. Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1