Isolating part of a chart

[Charles Eaves]

I am new to Excel 2007 using Xp Home.
I am plotting my blood tests: HbA1c,LDL,HDL and triglycerides.
The tests were taken in 2006 and 2007.
The data for HbA1c is: 5.8 and 7.2.
The data for the LDL,HDL and Triglycerides ranges from 46 to 141.
I am using vertical columns for the chart.
As you can see, the chart for the HbA1C readings are very small compared to
the other three.
I am told that I can right click on the HbA1c graph and plot it by itself.
That way, the vertical scale would be from 0 to 8.
I can graph the HbA1c by itself by going into design/data/....../etc and the
graph for the HbA1c works fine.
How do I isolate the graph of the HbA1c data by itself by picking it off the
large graph of HbA1c,LDL,HDL and triglycerides?
Thanks

 

[Guest]

I'm not particularly adept with charts, but Jon Peltier certainly seems to
be. You might browse through his pages on charting and see if there isn't
something you can use to solve the problem:
http://peltiertech.com/Excel/Charts/index.html

 

[Debra Dalgleish]

Right-click on the HbA1c series, and click on Format Data Series
On the Axis tab, select Secondary Axis, and click OK
Right-click on the series again, and click on Chart Type
Click on Line chart, and click OK.