Horizontally Banded Chart Background.

Horizontally Banded Chart Background. - on Stock charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JDB - 12 May 2008 00:54 GMT

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

Reply to this Message

Andy Pope - 12 May 2008 09:14 GMT

Hi,

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

Cheers
Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

>I have 3 series of data, Hi/Lo/Avg that I am plotting using a Stock
> type chart with 3 data points.
[quoted text clipped - 14 lines]
>
> JDB

Reply to this Message

Jon Peltier - 12 May 2008 13:18 GMT

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
_______

> Hi,
>
[quoted text clipped - 20 lines]
>>
>> JDB

Reply to this Message

JDB - 13 May 2008 05:38 GMT

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" <jonxlmv...@SPAMpeltiertech.com>
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
[quoted text clipped - 39 lines]
>
> - Show quoted text -

Reply to this Message