Drawing on an Excel chart

[puggit]

I'm producing some column charts in Excel - comparing data over some years. How can I go about highlighting one column to indicate when something changed?

[puggit]

Jay-Aim said:

If I understand it right..... Draw an arrow pointing to the change (or buble or else) highlight cells to include chart and set print area

Thanks

Gosh that was simple

[puggit]

OK - next question is trickier

I have a series of worksheets, all including the same type of data for different sites. All the data is in the same size table.

How do I copy the format of a chart from worksheet to worksheet?

If I copy/paste it just copies the chart en-masse from the other sheet. There is no paste-special.

Thanks in advance!!!

[puggit]

Jay-Aim said:

It's Sunday night Puggit you know...and mother's day too