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
|
|||
|
|||
3 axis chart
Is it possible to create a 3 axis chart ? I want the bottom x axis to import
names from a row on a spread sheet. The Y axis will contain the value of a score from the same sheet, 0 -100 in increments of 20. And a third axis on top of the chart to contain the 12 months of the year. Thank You |
#2
|
|||
|
|||
3 axis chart
You can have secondary axes on both the horizontal and vertical axes.
First you need at least two series. Double click one and on the Axis tab, check the Secondary option. This usually gets you just a secondary Y axis. To mix and match your choices, right click the chart and choose Chart Options. Click on the Axes tab, and check and uncheck the combination of axes you need. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Shorty wrote: Is it possible to create a 3 axis chart ? I want the bottom x axis to import names from a row on a spread sheet. The Y axis will contain the value of a score from the same sheet, 0 -100 in increments of 20. And a third axis on top of the chart to contain the 12 months of the year. Thank You |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Timeline chart from text containing cells | K. Georgiadis | Charts and Charting | 6 | June 8th, 2004 12:19 AM |
Clustered Column Chart with Second Axis | Jon Peltier | Charts and Charting | 0 | April 10th, 2004 04:56 AM |
Dual axis with Bar chart + two series : is it possible ?? | lOURY | Charts and Charting | 3 | February 20th, 2004 03:55 PM |
Two Y axis with different scales for a line chart | vacaut | Charts and Charting | 3 | October 30th, 2003 01:36 PM |
data to chart on primary axis | jw | Charts and Charting | 6 | September 24th, 2003 12:46 AM |