A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

3 axis chart



 
 
Thread Tools Display Modes
  #1  
Old July 2nd, 2004, 05:47 AM
Shorty
external usenet poster
 
Posts: n/a
Default 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  
Old July 2nd, 2004, 12:33 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 04:01 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.