Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
chrisH
 
Posts: n/a
Default HOW TO CREAT 3 AXIS CHARTS

how do i created multiple axis charts (speciffically i need to create a chart
with 3 axis for each separate series of data
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: HOW TO CREAT 3 AXIS CHARTS

Creating a chart with three axes can be a bit tricky, but it is definitely possible in Microsoft Excel. Here's how you can do it:
  1. First, select the data that you want to use for your chart. Make sure that you have all the data that you need for each separate series of data.
  2. Next, click on the Insert tab in the ribbon at the top of the Excel window. Then, click on the Recommended Charts button to see a list of chart types that Excel recommends for your data.
  3. Scroll down until you see the All Charts tab, and then click on it. From there, you should see a list of all the available chart types in Excel.
  4. Look for the chart type called "Combo". This is the chart type that allows you to create a chart with multiple axes.
  5. Select the "Combo" chart type, and then click on the OK button to create a new chart.
  6. In the "Combo Chart" dialog box that appears, you'll see a list of all the available chart types that you can use for your chart. For each series of data that you want to add to the chart, select the chart type that you want to use from the drop-down menu.
  7. Once you've selected the chart type for each series of data, you can then customize the chart by adding titles, labels, and other formatting options.
  8. To add a third axis to the chart, click on one of the series of data in the chart. Then, right-click and select "Format Data Series" from the context menu.
  9. In the "Format Data Series" dialog box, you'll see a section called "Series Options". Under this section, you should see an option called "Plot Series On". Click on the drop-down menu next to this option, and then select "Secondary Axis".
  10. Repeat this process for each series of data that you want to add to the third axis.

That's it! You should now have a chart with three axes, with each separate series of data plotted on its own axis.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default HOW TO CREAT 3 AXIS CHARTS

Do you want an XYZ chart?
http://andypope.info/charts/3drotate.htm

Do you want primary, secondary, and tertiary axes?
http://peltiertech.com/Excel/Charts/TertiaryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"chrisH" wrote in message
...
how do i created multiple axis charts (speciffically i need to create a
chart
with 3 axis for each separate series of data



  #4   Report Post  
Posted to microsoft.public.excel.charting
Rich K
 
Posts: n/a
Default HOW TO CREAT 3 AXIS CHARTS

To make Excel plots with 2 OR MORE Y axes, go to
www.OfficeExpander.com. They have an Excel tool to make Multiple Y
axis plots out of Excel charts. You just click the charts names in a
form.
Regards,
-Rich

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
The best method for forumlas and charts??? Sharon Excel Discussion (Misc queries) 0 May 9th 05 11:56 PM
charts....x and y axis Hazeus Charts and Charting in Excel 5 March 12th 05 05:19 AM
Locking the scale ratio of X-Y axis in XY scatter charts DK-Mech Charts and Charting in Excel 4 January 28th 05 10:13 AM
combing two bar charts to share one axis Penny Charts and Charting in Excel 3 January 27th 05 06:15 PM
change axis info on radar charts alfred Charts and Charting in Excel 1 January 11th 05 05:36 AM


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

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

About Us

"It's about Microsoft Excel"