Dynamic charts

J

jamesjra

Hi

I have a set template of a chart (just a simple bar) and i'd like to b
able to alter the chart by selecting data from various sources.

IE, The same template call Data for Question1 and displays th
respective results and then when I select Question2, the same templat
will display the data for question 2, etc

Any help would be much appreciated

Many Thanks

Jcalver
 
T

Tushar Mehta

You can probably adapt the ideas in Excel | Tutorials | 'Dynamic
Charts' on my web site, especially combining ideas from examples 3
through 6.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One extra x axis item that wont go away - can anyone help? 3
Average bar charts with individual data points 2
Odd Chart Format Results 1
Employee Schedule not plotting properly - chart type / data series not correct 0
One Chart, Same Data ranges, different source sheets 4
Dynamic (?) chart 0
sideways stacked bar charts with line series on the same axis 0
Dynamic series in rows 1

Top