How to mark key dates on chart?
 

I have a chart that shows change in blood pressure over time. I would like
to mark on the graph certain key dates (x values), for example where diet
changes. Can I do that with excel charts?



Also, I would like to highlight a band of y values (e.g. blood pressure
between 120-140). Can I do that?



Thanks for any help,



Huck

How to mark key dates on chart?
 

"Huck Rorick" wrote in message
...
I have a chart that shows change in blood pressure over time. I would like
to mark on the graph certain key dates (x values), for example where diet
changes. Can I do that with excel charts?

Format/ Data points/ Data labels/ X value

Also, I would like to highlight a band of y values (e.g. blood pressure
between 120-140). Can I do that?

Add a couple of extra series Xmin and Xmax, Y values for both 120, similarly
Xmin Xmax, Y values for both 140. Add these series to your chart.
--
David Biddulph

How to mark key dates on chart?
 

Hi David,



I tried your suggestions but had a few problems. I am using Excel 2002.

The "Format" menu didn't have anything on Data points/ Data labels/ X value.

If I right click on the chart and select "chart options" there is a "Data
Labels" tab. However, checking "X Value" puts the X value at every data
point. I only want to highlight a particular spot on the chart.



Is there any way to add a text note to a chart?



I'm not sure I understood your second suggestion

Add a couple of extra series Xmin and Xmax, Y values for both 120, similarly
Xmin Xmax, Y values for both 140. Add these series to your chart

I probably should have mentioned that this is a scatter chart. If I add
another series it will put in a series of points, which wouldn't look too
good. Did you mean to add a series of data points? If it were a line chart
then that would probably get pretty close to what I want, but on the scatter
chart I can't see that it would work.



Any clarification or other idea?



Thanks,



Huck

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
"Huck Rorick" wrote in message
...
I have a chart that shows change in blood pressure over time. I would
like to mark on the graph certain key dates (x values), for example where
diet changes. Can I do that with excel charts?

Format/ Data points/ Data labels/ X value

Also, I would like to highlight a band of y values (e.g. blood pressure
between 120-140). Can I do that?

Add a couple of extra series Xmin and Xmax, Y values for both 120,
similarly Xmin Xmax, Y values for both 140. Add these series to your
chart.
--
David Biddulph

How to mark key dates on chart?
 

Huck:

This link shows how to add comments to a trend chart.

http://processtrends.com/pg_charts_t...ith_events.htm

Kelly O'Day



"Huck Rorick" wrote in message
...
Hi David,



I tried your suggestions but had a few problems. I am using Excel 2002.

The "Format" menu didn't have anything on Data points/ Data labels/ X
value.

If I right click on the chart and select "chart options" there is a "Data
Labels" tab. However, checking "X Value" puts the X value at every data
point. I only want to highlight a particular spot on the chart.



Is there any way to add a text note to a chart?



I'm not sure I understood your second suggestion

Add a couple of extra series Xmin and Xmax, Y values for both 120,
similarly
Xmin Xmax, Y values for both 140. Add these series to your chart

I probably should have mentioned that this is a scatter chart. If I add
another series it will put in a series of points, which wouldn't look too
good. Did you mean to add a series of data points? If it were a line
chart then that would probably get pretty close to what I want, but on the
scatter chart I can't see that it would work.



Any clarification or other idea?



Thanks,



Huck

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
"Huck Rorick" wrote in message
...
I have a chart that shows change in blood pressure over time. I would
like to mark on the graph certain key dates (x values), for example where
diet changes. Can I do that with excel charts?

Format/ Data points/ Data labels/ X value

Also, I would like to highlight a band of y values (e.g. blood pressure
between 120-140). Can I do that?

Add a couple of extra series Xmin and Xmax, Y values for both 120,
similarly Xmin Xmax, Y values for both 140. Add these series to your
chart.
--
David Biddulph

How to mark key dates on chart?
 

"Huck Rorick" wrote in message
...
Hi David,

I tried your suggestions but had a few problems. I am using Excel 2002.

The "Format" menu didn't have anything on Data points/ Data labels/ X
value.

If I right click on the chart and select "chart options" there is a "Data
Labels" tab. However, checking "X Value" puts the X value at every data
point. I only want to highlight a particular spot on the chart.

If you click once on a series in the chart, then either right-click or the
format menu will give you Format Data Series. If you click twice, then
instead of Format Data Series you'll get Format Data Points.

Is there any way to add a text note to a chart?

I'm not sure I understood your second suggestion

Add a couple of extra series Xmin and Xmax, Y values for both 120,
similarly
Xmin Xmax, Y values for both 140. Add these series to your chart

Put in a column firstly your minimum X value then your maximum X value. In
the adjacent column put 120 then 120. In the next column put 140 then 140.
Select this range (2 rows by 3 column), copy, then select your chart, go to
the Edit menu, find Paste Special. Select the options for "new series",
data in "columns", X values in 1st column. This should give you one
horizontal line at 120 and another at 140. You can label the lines with
series names if you want to.

I probably should have mentioned that this is a scatter chart. If I add
another series it will put in a series of points, which wouldn't look too
good. Did you mean to add a series of data points? If it were a line
chart then that would probably get pretty close to what I want, but on the
scatter chart I can't see that it would work.

You obviously haven't realised that a scatter chart isn't limited to
isolated points. The "scatter" title obviously confuses some people, but
most of us use that type of chart and include lines between the points. If
you go to Chart Type and look at the sub-type options, you'll see the
options include either point symbols with lines between them or lines
without point symbols. You can also play around with individual data series
(or even individual data points) and add, remove, or change the lines and/or
point symbols.

Any clarification or other idea?

Thanks,

Huck
--
David Biddulph

How to mark key dates on chart?
 

Thanks for all the help. I'm back to the drawing board.

Huck

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
"Huck Rorick" wrote in message
...
Hi David,

I tried your suggestions but had a few problems. I am using Excel 2002.

The "Format" menu didn't have anything on Data points/ Data labels/ X
value.

If I right click on the chart and select "chart options" there is a "Data
Labels" tab. However, checking "X Value" puts the X value at every data
point. I only want to highlight a particular spot on the chart.

If you click once on a series in the chart, then either right-click or the
format menu will give you Format Data Series. If you click twice, then
instead of Format Data Series you'll get Format Data Points.

Is there any way to add a text note to a chart?

I'm not sure I understood your second suggestion

Add a couple of extra series Xmin and Xmax, Y values for both 120,
similarly
Xmin Xmax, Y values for both 140. Add these series to your chart

Put in a column firstly your minimum X value then your maximum X value.
In the adjacent column put 120 then 120. In the next column put 140 then
140. Select this range (2 rows by 3 column), copy, then select your chart,
go to the Edit menu, find Paste Special. Select the options for "new
series", data in "columns", X values in 1st column. This should give you
one horizontal line at 120 and another at 140. You can label the lines
with series names if you want to.

I probably should have mentioned that this is a scatter chart. If I add
another series it will put in a series of points, which wouldn't look too
good. Did you mean to add a series of data points? If it were a line
chart then that would probably get pretty close to what I want, but on
the scatter chart I can't see that it would work.

You obviously haven't realised that a scatter chart isn't limited to
isolated points. The "scatter" title obviously confuses some people, but
most of us use that type of chart and include lines between the points.
If you go to Chart Type and look at the sub-type options, you'll see the
options include either point symbols with lines between them or lines
without point symbols. You can also play around with individual data
series (or even individual data points) and add, remove, or change the
lines and/or point symbols.

Any clarification or other idea?

Thanks,

Huck
--
David Biddulph