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?

[Jay-Aim]

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

[Big Al.]

Have you tried conditional formatting fuction?

[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!!!

[Jay-Aim]

puggit said:

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!!!

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



now copy and paste chart from 1 spreadsheet to an other

right click chart and select source data
alter as required
done

now go watch Coro in a minute

[puggit]

Jay-Aim said:

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