L
LiAD
Hi,
I tried this post before with no luck yet, so I thought i'd try again.
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, as soon as I open the source
data box 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?
Thanks for your help
I tried this post before with no luck yet, so I thought i'd try again.
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, as soon as I open the source
data box 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?
Thanks for your help