Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a regression line in a graph | Charts and Charting in Excel | |||
Creating a distribution Graph. | Charts and Charting in Excel | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Creating a graph | Excel Worksheet Functions | |||
creating a directed graph from XY scatter | Charts and Charting in Excel |