Content Management, Technology and other thoughts.

Creating multiple y axis graph in excel 2007

Ok this was annoying to figure out so here you go.
I was trying to create 2 axis graph, or chart, in Excel since the relationship of the data was not very good. one was in the tens and the other was in the thousands.
First create a graph using your data and select the type you like. in our case it was a 2 line graph.

then right click on the smaller graph, the blue one in our case, and select the “Format Data Series…”

Then we get a popup window for the series options with the ability to change the series axis.

We select the Secondary axis option and close the window using the Close button.
The graph will update and set for 2 Y axis display.

P.S. the process can be repeated for more lines and more Y axis.

"Creating multiple y axis graph in excel 2007" was published on September 16th, 2008 and is listed in Management, Microsoft Office Excel.

Follow comments via the RSS Feed | Leave a comment | Trackback URL

Related Posts

Comments on "Creating multiple y axis graph in excel 2007": 18 Comments

  1. bjornstar wrote,

    links from Technorati

  2. excel multiple axis graph - Web - WebCrawler wrote,

    Kramer auto Pingback[...] axis values. http://www.tech-archive.net/pdf/Archive/Excel/microsoft.p... [Found on Ask.com] Creating multiple y axis graph in excel 2007 | Yuval Ararat "Creating multiple y axis graph in excel 2007" was published on September 16th, 2008 [...]

  3. sk wrote,

    Thank you so so much…saved me so many hours of looking around and exploring options. :)

  4. Sanford Silverburg wrote,

    I need to create a y-axis with two sets of values, from the x-axis from 0 with intervals of .5 to 20 with intervals thereafter of 10. Need help.

  5. Tess wrote,

    You’re wonderful! I tried figuring this out using the Excel help and the options they listed were not even visible. Your way took mere seconds!

    THANK YOU!

  6. Anonymous wrote,

    thanks alot.. have been trying to find out since 3 days…s

  7. Mr.Chemic wrote,

    Super! Very good work. This method is very important for me. Now I am trying to draw secondary axis in MS Excel 2003. For Excel 2007 is very easy! Thank you again!

  8. TF wrote,

    This is so easy!! Thanks, you saved me so much time and heartache

  9. Anonymous wrote,

    Thankyou Dear, It saved my exploring the solution on net

  10. Anonymous wrote,

    Thank you so much! I struggle to find things in 2007 and was tearing my hair out over this.

  11. Jaimie wrote,

    I have another question regarding this — Can I have the first axis Y data be in bars and the second axis data be in lines?

    Thanks

  12. Jaimie wrote,

    I have another question regarding this….Can I have the first axis Y data be in bars and the second axis Y data be in lines?

    Thanks

  13. yuval wrote,

    Yes.
    In the second photo you will find the “Change Series Chart Type…” (3rd option from the top after you right click the series). Click on it and it will let you change the series to any chart type that you want.
    But not all of the Chart Types work correctly so be careful in the type you select and validate that nothing was omitted from the results.
    Cheers!

  14. Anonymous wrote,

    Thanks alot, this saved me alot of time and stress

  15. creating line charts in 2007 with multiple - Dogpile Web Search wrote,

    Kramer auto Pingback[...] Online. Shop Target.com. Sponsored by: http://www.Target.com • Found on Ads by Yahoo! Creating multiple y axis graph in excel 2007 | Yuval Ararat I was trying to create 2 axis graph, or chart, in Excel since the relationship of … your data [...]

  16. John doe wrote,

    THANK YOU SO MUCH! you saved me so much time

  17. Siddo wrote,

    Thanks for taking the time to share!

  18. Lacuzygirl wrote,

    Thanks so much you’re a life saver with this one! it actually helped me get my project report off the ground.

Leave Your Comment