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