Thanks Jon - the custom chart seems the way to go.

"Jon Peltier" wrote:


The problem is also that with the data set I have it takes a long time to
update the sheet when I re-import my data.

....because...? If the new data has the same layout as the old, copy it from
its original worksheets, then paste special as values onto the worksheets
used as source data by the charts.

I inhearited the workbook so my other reason for doing this is that I want
all my charts to be the same from one sheet or workbook to another.

Make a few user-defined chart types:

http://peltiertech.com/Excel/ChartsH...stomTypes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______