Unwanted chart formatting changes!

[witham]

Hi all,

I have set up a reporting dashboard that updates automatically every time new data is inserted into another worksheet I use as a database.

Initially the dashboard was not dynamic and looked great but every time I updated the data I had to update each graph. Now it is all dynamic and as new data is entered all the graphs beautifully update. BUT every time I add new data, the graphs reset to the default formatting.

Any ideas anyone? I am running Excel 2003 & Windows 7.

Thanks in anticipation and have a great week!

 

[Gerald Higgins]

Really ? Formating, such as chart bar fill colours, fonts etc all change when the data changes ?
I've never seen this before.

Are you updating the charts through VBA somehow ?

 

[witham]

Hey Gerald,

No I'm not. They are just updating by different formulas (e.g. vlookups) that get them to look at certain elements of the data entries.

The data table itself is a dynamic table created in LISTS/TABLES (CTRL+L)

Tim

 

[Gerald Higgins]

OK so just to be clear, what formating features change ?

 

[witham]

IT is the plot lines on the graphs, plotting points format (shape, colour), colour of lines and colours on bars of bar graphs.

T.

 

[Gerald Higgins]

OK, I'll see if I can replicate that. I've never used LISTS/TABLES, but I've used charts that I update lots of times, and have never encountered format changes like this.

 

[witham]

Hi Gerald,

Wierdly since doing a SaveAs, rename and open, it seems to have resolved. Maybe I had gremlins in the spreadsheet.

Either way, I am stumped but somewhat relieved!

Thanks for taking a look though!

T.