Chart Format issues

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Stock Format Issues 2
Formatting STOCK charts 6
How to create a bubble chart with more than 2 variables. 0
Move Chart with Text 0
Gantt chart duration not showing 0
Save a custom chart as a template 0
Possible to Combine reports to's to a single box? 0

Top