Goal range in a graph

[Guest]

Is there any way to create a "goal range" in PPT? It's a feature that Harvard
Graphics has had for years...On a bar chart, for example, you might have four
bars that you'd like to compare to a certain value or range. HG offers the
option of creating a "goal range" that then puts a shaded area on the graph's
axis indicating the range of values that you can then compare the bars to...

 

[Echo S]

Off the top of my head, I suspect the easiest way to do this in PPT would be
to draw in a semitransparent rectangle.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

Is there any way to create a "goal range" in PPT? It's a feature that Harvard
Graphics has had for years...On a bar chart, for example, you might have four
bars that you'd like to compare to a certain value or range. HG offers the
option of creating a "goal range" that then puts a shaded area on the graph's
axis indicating the range of values that you can then compare the bars

to...

 

[Guest]

Thanks - I hoped there was a way to do it without having to manually create
an approximately correctly sized rectangle and placing it on the chart.

Off the top of my head, I suspect the easiest way to do this in PPT would be
to draw in a semitransparent rectangle.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

Is there any way to create a "goal range" in PPT? It's a feature that Harvard
Graphics has had for years...On a bar chart, for example, you might have four
bars that you'd like to compare to a certain value or range. HG offers the
option of creating a "goal range" that then puts a shaded area on the graph's
axis indicating the range of values that you can then compare the bars

to...

 

[Echo S]

Well, you could add horizontal data points as a line graph so you know it's
sized correctly. But I don't think you can fill the area between the two
lines. There's probably a way to fake it, though -- maybe using an area
chart for the goal range.

Oh, look here. This might help you work through it.

http://groups.google.com/group/micr...553bd0b9590fa8d?sa=X&oi=groupsr&start=0&num=3

That technique should be doable in PPT's graph, as it doesn't rely on
formulas or anything.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

Thanks - I hoped there was a way to do it without having to manually create
an approximately correctly sized rectangle and placing it on the chart.

Off the top of my head, I suspect the easiest way to do this in PPT would be
to draw in a semitransparent rectangle.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

Is there any way to create a "goal range" in PPT? It's a feature that Harvard
Graphics has had for years...On a bar chart, for example, you might

have
four

bars that you'd like to compare to a certain value or range. HG offers the
option of creating a "goal range" that then puts a shaded area on the graph's
axis indicating the range of values that you can then compare the bars

to...

 

[Andy Pope]

Hi,

I have put together a few examples. But I haven't seen the HG feature so
they may not match exactly.

http://www.andypope.info/ngs/ng46.htm

Cheers
Andy

Thanks - I hoped there was a way to do it without having to manually create
an approximately correctly sized rectangle and placing it on the chart.

:

Off the top of my head, I suspect the easiest way to do this in PPT would be
to draw in a semitransparent rectangle.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

Is there any way to create a "goal range" in PPT? It's a feature that
Harvard

Graphics has had for years...On a bar chart, for example, you might have
four

bars that you'd like to compare to a certain value or range. HG offers the
option of creating a "goal range" that then puts a shaded area on the
graph's

axis indicating the range of values that you can then compare the bars

to...