How to make a Chart refer to data from a specific worksheet

**atja** · 01-26-2012, 10:02 AM

Hi,

I have a question about selecting chart data in Excel.

My workbook has a number of worksheets, which have exactly the same
layout, but different data on them. On another worksheet I have a
chart that plots data from one of these worksheets. Now I want to make
an option such that a user can enter the name of a worksheet in a cell
on the worksheet with the plot, so the plot shows the data from that
specific worksheet.

Any idea how I can do this? Any help would be highly appreciated!

Thanks,
atja

**dilipandey** · 01-27-2012, 12:56 AM

Hi atja,

Welcome to the forum.
It seems to be achievable. I have done something for you, see the attachment and let me know if this can help you to start. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**MarvinP** · 01-27-2012, 01:13 AM

Hi atja and welcome to the forum,

After looking all over for how dilipandey changed his chards I decided to do it a little differently. I keep the data you draw the chart on on a single sheet. I simply put an INDIRECT formula in those cells which changes based on the dropdown tab name. See if my answer is a little easier to accomplish.

This just shows there are many ways to accomplish a task using Excel.