Sorry,

It makes no difference as soon as I open the source data dialogue box the
chart has already reformatted. Whether I use the data range or series tab
makes no difference.

Should this matter?

"Jon Peltier" wrote:

You never told us how you are changing the selections in the Source Data
dialog. Are you changing the Data Range selection or the series in the
Series tab?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"LiAD" wrote in message
...
Thanks for the suggestions.

I will try the custom approach.

Their must be an option somewhere that I can adjust that is different in
mine to other peoples as no-one else looses the format. I can't avoid
losing
it whatever way I try to change the data range. Even a brand new change
reformats itself in the same way.

Thanks

"Jon Peltier" wrote:

I don't have this problem when I change the source data in one step on
the
Data Range tab of the dialog. If I change the individual OHLC data in the
Series tab, the chart loses its custom formatting. You should try to use
the
Data Range tab of the dialog, because the series make less sense out of
context.

If you have to change each series individually, you can use the colored
rectangles highlighting the data in the sheet behind the chart. If you
select the whole chart, the category labels are highlighted with purple
lines, the series names with green, and the values with blue. If you
select
just one series, these same parameters for just the series are
highlighted.
You can move and resize these rectangles by clicking and dragging to
adjust
the source data ranges. When I do this series by series, the chart
retains
its formatting.

Another approach is to save the chart as a custom chart type, then
reapply
it after adjusting the data, as described he
http://peltiertech.com/Excel/ChartsH...stomTypes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"LiAD" wrote in message
...
Hi,

Sorry i've tried this post before with no solution yet, but
unfortunately
i
need to find one quite soon.

I am using a STOCK type chart in excel with the table formatted in the
required
A B etc (up to 20 x-axis categories)
Av
Max
Min
Close

way. In order to make the chart more 'viewable' I have changed the
colours,
sizes, bars etc as normal.

However if I need to change the range of data using the source data
option
the chart reverts back to the default excel format of small bars, thin
lines
etc and I loose the items that I formatted.

Can I stop this happening?
Why does it only happen to this type of chart and no other charts I
use?
Where I can open this dialogue box without loosing formats

Thanks for your help