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
|
|||
|
|||
Charting in 2 axises
I need to chart on 2 axises showing the data as two
separate columns next to each other. When I chart the two columns I lose my second axis on my chart. When I show my second axis on the chart, then the two columns are laid on top of each other. I want my second axis to show but I want the two columns to show as separate next to each other. |
#2
|
|||
|
|||
What about changing your chart to a 3d model. 3d models can be panned to any angle which will enable you to see overlays. It's too bad there's not an image pasting function here. I have some graphs that are 3d that might make more sense if seen. -- Chris Brennan ------------------------------------------------------------------------ Chris Brennan's Profile: http://www.excelforum.com/member.php...o&userid=14915 View this thread: http://www.excelforum.com/showthread...hreadid=265542 |
#3
|
|||
|
|||
Joan -
You need some blank data to keep the columns to the left or right of center. This web page explains how: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Joan Perry wrote: I need to chart on 2 axises showing the data as two separate columns next to each other. When I chart the two columns I lose my second axis on my chart. When I show my second axis on the chart, then the two columns are laid on top of each other. I want my second axis to show but I want the two columns to show as separate next to each other. |
#4
|
|||
|
|||
For the most part, 3D charts are more difficult to interpret. Joan will have better
results using my suggestion to keep the chart in 2D. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Chris Brennan wrote: What about changing your chart to a 3d model. 3d models can be panned to any angle which will enable you to see overlays. It's too bad there's not an image pasting function here. I have some graphs that are 3d that might make more sense if seen. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
help!save my job...charting time is causing me headache! | kerry78 | Charts and Charting | 4 | August 27th, 2004 05:56 PM |
Charting a normal distribution within excel.. | Michael R Middleton | Charts and Charting | 1 | May 25th, 2004 06:01 PM |
Interesting Web blog on Excel charting obsessions | Eva Whitley | Charts and Charting | 1 | May 19th, 2004 01:57 AM |
charting flight loads | Tushar Mehta | Charts and Charting | 0 | May 10th, 2004 01:25 PM |
charting flight loads | fatmaninspeedos | Charts and Charting | 0 | May 10th, 2004 02:14 AM |