If your data is structured the same way, the easiest thing to do is make
a copy of the worksheet that hosts the data and chart you've already
created, copy a new question's data over the old data, and the chart
will automatically update.
If the data isn't so nicely arranged, you can turn the chart into a
custom user defined type:
http://peltiertech.com/Excel/ChartsH...stomTypes.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
rgraham1 wrote:
Hi,
I've got a bunch of survey results. Most are multiple choice questions and
responses. I want to create a chart showing the results for each of the 40
questions.
I just created one chart and it took me about 15 minutes.
Is there a way that I can use this chart as a "template" to create the other
39 charts I need to do?
thanks,