![]() |
|
![]() |
![]() | Customer: Sign in Delegate: Sign in Trainer: Log in |
|
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel charts - chart colour & source data Excel charts - chart colour & source dataThe UK's most regular instructor-led training courses.
Excel charts - chart colour & source data
Simon has attended:
This is really driving me mad - I've got to produce a number of column charts and so I've created the first one which I then want to copy and change the source data range for each new chart. Although the source data is identically formatted and arranged for each chart, the chart colours change and the legend goes wonky with a colour square left hanging without a description. Very grateful for your advice on this.
RE: Excel charts - chart colour & source data
Have you tried to define your own type of chart? RE: Excel charts - chart colour & source data
I just followed your instructions & the same formatting problems still occur when I select the custom chart type that I saved - I just don't understand it - the other data is identically arranged, it's just in a different part of the worksheet. Sorry - any other suggestions? Thanks, Simon RE: Excel charts - chart colour & source data
I only have one other suggestion, but not sure if it will make a difference. RE: Excel charts - chart colour & source data
This crossed my mind as well... and it still doesn't work! I can't believe how useless Excel is - surely this must cause problems to large numbers of users? RE: Excel charts - chart colour & source data
Humble apologies are due to yourself & Microsoft - I've just realised that the second data table contained a column narrowed to the point of invisibility which was messing up the chart! Thanks for your help, Simon.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Mini sitemap. These are the main areas of our web site. Full sitemap.
| |||||||||||||||||||
© 2008 Best STL. All
Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms
and Conditions