plotting with 4 series

I

Inkah

I have some data that needs to be on the same line chart each piece of data gos up by a different amount ie 100,000, 20, 10 and 100, is it possible to do this and how can I do it, hope someone can help

Thanks
 
J

Jon Peltier

Is it a matter of plotting one series on a secondary axis because of the
great difference in value? Plot all series together on one chart, then
double click the series with extreme values, click on the Axis tab, and
choose Secondary.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Chart series select. 3
Data points in chart incorrect 0
How to change series plotting order without changing legend order? 6
XY scatter plot with more than 32000 rows in Excel 2003 0
Convert Error Bars to Series and Colour 1
How to Plot This Data? 2
Auto selection of Data 1

Top