|
| 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
October 1st, 2004, 05:19 PM
|
|||
|
|||
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
October 1st, 2004, 07:52 PM
|
|||
|
|||
|
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
October 3rd, 2004, 06:24 AM
|
|||
|
|||
|
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
October 3rd, 2004, 06:26 AM
|
|||
|
|||
|
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 |
Linear Mode
