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