If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2nd axis graph
I am running Office/Windows 2K. I have a spreasheet that contains
names of cities. Next to this column I have two sets of data. I wish to create a bar chart that will plot the city names along the x axis and then have two y axis to display the 2 different sets of data. I can create the second y axis, however, this creates a stacking bar chart which I do not want. Does anyone know how to do this? Many thanks. Regards Ket |
#2
|
|||
|
|||
2nd axis graph
Ket -
What appear as stacking bars are likely two sets of bars, one in front of the other, instead of side by side. You can make a side by side column chart on two axes following this example, which uses dummy series to offset the visible series: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Ket wrote: I am running Office/Windows 2K. I have a spreasheet that contains names of cities. Next to this column I have two sets of data. I wish to create a bar chart that will plot the city names along the x axis and then have two y axis to display the 2 different sets of data. I can create the second y axis, however, this creates a stacking bar chart which I do not want. Does anyone know how to do this? Many thanks. Regards Ket |
#3
|
|||
|
|||
2nd axis graph
Thanks Jon, worked a treat.
On Tue, 20 Jul 2004 13:52:44 -0400, Jon Peltier wrote: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Two Y axis in Graph | Debra Dalgleish | Charts and Charting | 0 | March 20th, 2004 09:39 PM |
force graph to axis of choice | bbxrider | Charts and Charting | 2 | February 12th, 2004 09:51 PM |
force graph to axis of choice | Tushar Mehta | Charts and Charting | 3 | February 11th, 2004 04:04 PM |
Line graph along a single axis | conaghan | Charts and Charting | 1 | November 29th, 2003 09:05 PM |