Use a different spreadsheet as source data

A

Annette

Presently, I have a radar comparing YTD actual 2009 vs YTD budget 2009 but I
want to provideto user the capability of seeing maybe actual 2008 vs budget
2008. Meaning that I am looking for a way to change the automatically not the
X or Y (it will remain the same) but change the sheet used as the source data
for the graph
 

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

determine a range using a formula 2
Help with "clusters" of plotted data 2
Hide line and legend when data not present 0
VBA to automatically change source data for existing chart 3
Employee Schedule not plotting properly - chart type / data series not correct 0
stacked column- value axis not displaying correct values 0
how to combine two data source into one pivot table 2
what function or formula can I use 6

Top