How to plot data in one sheet into another sheet

[Conair1]

Hello,

I have a workbook called Master.xlsx that has all the data for various stations for different months in a year. This data is stored in sheet1 of Master.xlsx

I would like the vba to plot this data on different spreadsheets according to their Station Names. The Plot should be in 2-D Coloumn chart type and y-axis should be the data values and x-axis should be months(May, June,July etc..).

[dilipandey]

HI Conair1,

welcome to the forum.

Okay.. so you need help in plotting the chart
or,
you need to know if plotting data from other sheet / workbook is possible ?

Regards,
DILIPandey
<click on below * if this helps>

[Conair1]

Hello, thanks for getting back to me.. I need help in plotting a chart on another sheet (ex. Station1) using the data that is on sheet1.. I hope this clarifies, Thank you.

[dilipandey]

Hi Conair1,

You can achieve this using pivot table / chart where "show pages" option is there which will create tabs automatically based on station names (filter), see attached workbook (col I, J,K,L)

Book1.xlsx

Regards,
DILIPandey
<click on below * if this helps>

[Conair1]

Hi,

Thank you for your response. Just a question, did you create the data in coloums I,J,K,L automatically?

[dilipandey]

Hi Conair1,

No I did not created that data automatically but suggested that you should structure your data table like that


Regards,
DILIPandey
<click on below * if this helps>

[Conair1]

Ok sounds good, thank you!

[dilipandey]

Cheers

Please mark this thread as [SOLVED]... Thanks.

Regards,
DILIPandey
<click on below * if this helps>