I have 3 series of data, Hi/Lo/Avg that I am plotting using a Stock
type chart with 3 data points.

I want to use a Horizontally Banded Background to indicate the desired
range.

I have read and tested Jon P's excellent article on Horizontailly
Banded Chart Background, and tested it successfull on a line chart.

However when I test it on the 3 var Stock chart it does not work.

Can anyone give me a suggestion for a way to do what I want with
either my stock type of chart or an alternative way to show what I
want to indicate.

Thanks from American Samoa

JDB

Hi,

Can you provide a bit more information about what does not work exactly?

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"JDB" wrote in message
...
I have 3 series of data, Hi/Lo/Avg that I am plotting using a Stock
type chart with 3 data points.

I want to use a Horizontally Banded Background to indicate the desired
range.

I have read and tested Jon P's excellent article on Horizontailly
Banded Chart Background, and tested it successfull on a line chart.

However when I test it on the 3 var Stock chart it does not work.

Can anyone give me a suggestion for a way to do what I want with
either my stock type of chart or an alternative way to show what I
want to indicate.

Thanks from American Samoa

JDB

The protocol should work with a stock chart. Sometimes when working with
different chart types within the same chart, you reach an intermediate state
which looks nothing like where you started nor where you want to go, but you
have to proceed with the next step or two, and the chart types will stop
fighting with each other.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Andy Pope" wrote in message
...
Hi,

Can you provide a bit more information about what does not work exactly?

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"JDB" wrote in message
...
I have 3 series of data, Hi/Lo/Avg that I am plotting using a Stock
type chart with 3 data points.

I want to use a Horizontally Banded Background to indicate the desired
range.

I have read and tested Jon P's excellent article on Horizontailly
Banded Chart Background, and tested it successfull on a line chart.

However when I test it on the 3 var Stock chart it does not work.

Can anyone give me a suggestion for a way to do what I want with
either my stock type of chart or an alternative way to show what I
want to indicate.

Thanks from American Samoa

JDB

Thanks for the suggestion.

I converted the chart to a series of line charts, used the vertical
line feature to get my hi/lo/average, and added the banded background
and bingo.

What had happened before was that the data was added to the first 2
existing data points, and I could not seem to make it work.

All is well, thanks for your excellent charting turtorials. Saved
many a day.

JDB



On May 12, 1:18*am, "Jon Peltier"
wrote:
The protocol should work with a stock chart. Sometimes when working with
different chart types within the same chart, you reach an intermediate state
which looks nothing like where you started nor where you want to go, but you
have to proceed with the next step or two, and the chart types will stop
fighting with each other.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

"Andy Pope" wrote in message

...



Hi,

Can you provide a bit more information about what does not work exactly?

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"JDB" wrote in message
...
I have 3 series of data, Hi/Lo/Avg that I am plotting using a Stock
type chart with 3 data points.

I want to use a Horizontally Banded Background to indicate the desired
range.

I have read and tested Jon P's excellent article on Horizontailly
Banded Chart Background, and tested it successfull on a line chart.

However when I test it on the 3 var Stock chart it does not work.

Can anyone give me a suggestion for a way to do what I want with
either my stock type of chart or an alternative way to show what I
want to indicate.

Thanks from American Samoa

JDB- Hide quoted text -

- Show quoted text -