Post reply

line chart intervals

  • January 29, 2009 at 10:57 am

    #218115

    I have a line chart that has 6 series. One series called "Scan" has data in the millions, while the rest are in the thousands. I've attached a picture of it. How can i display all the 5 lines while still being able to show "Scan"? I tried changing the Y Axis Major and Minor Intervals to 1000, but it still display the same.

  • January 29, 2009 at 11:06 am

    #934913

    You should be able to enable scale breaks.

    Go to your Axis properties, and choose 'Enable scale breaks' under Axis options.

    HTH,

    Bill

  • January 29, 2009 at 11:26 am

    #934932

    According to msdn, here are the instructions to enable it, but i cant find it????

    To enable scale breaks on the chart

    Right-click the value axis and then click Axis Properties. The Axis Properties dialog box opens.

    Select the Enable scale breaks check box.

  • January 29, 2009 at 11:32 am

    #934939

    I should have asked which version you were using...Sorry...

    Those instructions are for 2008. I'm not certain if that exists in 2005. I'll check.

  • January 29, 2009 at 11:34 am

    #934940

    i have 2005

  • January 29, 2009 at 11:47 am

    #934954

    That feature is new in 2008...

    One thing you can try...Check the 'Logarithmic scale' option on the Y Axis. I made a test chart, and it does display the lines...

    Bill

  • January 29, 2009 at 11:54 am

    #934962

    thanks bill. that should work for now

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply