Results 1 to 1 of 1

Dropdown Menu in Line Chart and Y axis scale

Threaded View

  1. #1
    Registered User
    Join Date
    02-19-2013
    Location
    Jackson, MS
    MS-Off Ver
    Excel 2010
    Posts
    1

    Dropdown Menu in Line Chart and Y axis scale

    I have a line chart that contains a drop down list so each time an item is selected the item automatically updates. On all but two of the selections, the scale is proportional to the data. But on those two, the scale begins at 0. If I change the min and max it changes it for all the regions, which I do not want to do. Why are just these regions doing this and not all and how do I change it to scale properly?
    On another note, is there a way to have more than one item selected in the drop down menu so it will display the two line graphs over each other for comparison purposes?
    I have attached some sample data. Any questions, suggestions would be greatly appreciated.

    Thanks,

    Katie
    Attached Files Attached Files

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