+ Reply to Thread
Results 1 to 3 of 3

Second Line away from 0 and 3 data labels per chart row

  1. #1
    Registered User
    Join Date
    02-07-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    16

    Second Line away from 0 and 3 data labels per chart row

    Hi,
    I've been given a tornado chart which works very well, however im struggling to make a small modification to it.

    As you can see in the attached file, It starts away from zero if the base number is not zero, I like having the zero line there, but what i'm trying to do is add another line, which goes through the Base value. Ideally I also want to have a data label showing the base value for every midpoint of the tornado (this will be the same number on every row of the chart)

    In my attached file I have two tabs, one is the current chart, and the second tab shows the bits i've put in manually that i'm struggling to make it do automatically.

    I'm not sure if it's possible to put the second line in? Any thoughts?

    Many thanks,
    Nick
    Attached Files Attached Files
    Last edited by nickFe; 02-17-2011 at 09:54 PM.

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

    Re: Second Line away from 0 and 3 data labels per chart row

    You can add 2 xy-scatter series.
    One will draw the red line, similar to the blue line you already have.
    The second is used to display data labels showing the X value.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-07-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Second Line away from 0 and 3 data labels per chart row

    Quote Originally Posted by Andy Pope View Post
    You can add 2 xy-scatter series.
    One will draw the red line, similar to the blue line you already have.
    The second is used to display data labels showing the X value.
    Brilliant, Thanks Andy Pope. Exactly what I wanted to achieve.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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