creating a graph with three " Y" axis"
Hi there,
I am trying to create a line graph with three " Y" axis - I can create two using the secondary option but it does not allow for the third. Am I using the wrong graph option? What am I doing wrong ? |
creating a graph with three " Y" axis"
gweny,
You are limited to two - if you want to use a 'third', you really need to scale your data to fit one of the other two, then change the axis label to note that "line ??? is x10" or whatever.... HTH, Bernie MS Excel MVP "gweny" wrote in message oups.com... Hi there, I am trying to create a line graph with three " Y" axis - I can create two using the secondary option but it does not allow for the third. Am I using the wrong graph option? What am I doing wrong ? |
creating a graph with three " Y" axis"
Excel can't do what you want directly, but...
Jon Peltier has a very interesting set of web pages on making Excel charts do things they were never intended to do. Below is a link to his page that shows you one way to get what you want: http://www.peltiertech.com/Excel/Cha...tiaryAxis.html If you do a lot of charting, I'd recommend you spend half an hour just browsing through all Jon's web pages to get an idea of some of the surprising things you can make Excel charts do. Then if you ever come across a need for a speedometer chart, you'll know where to find it. Bill --------------------------- gweny wrote: Hi there, I am trying to create a line graph with three " Y" axis - I can create two using the secondary option but it does not allow for the third. Am I using the wrong graph option? What am I doing wrong ? |
All times are GMT +1. The time now is 12:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com