Isolating part of a chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charles Eaves - 17 Aug 2007 03:50 GMT

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

Reply to this Message

JLatham - 18 Aug 2007 14:28 GMT

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

> I am new to Excel 2007 using Xp Home.
> I am plotting my blood tests: HbA1c,LDL,HDL and triglycerides.
[quoted text clipped - 11 lines]
> large graph of HbA1c,LDL,HDL and triglycerides?
> Thanks

Reply to this Message

Debra Dalgleish - 18 Aug 2007 15:58 GMT

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.

> I am new to Excel 2007 using Xp Home.
> I am plotting my blood tests: HbA1c,LDL,HDL and triglycerides.
[quoted text clipped - 11 lines]
> large graph of HbA1c,LDL,HDL and triglycerides?
> Thanks

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message