Draw line graph automatically in each sheet

Topic

New Reply

Hi Experts
I need to plot a graph in each sheet automatically ,all the columns data in each sheet same format.
Sample attached containing two graphs needs to create in all sheets

Reply | Quote

Replies

You only provide ONE sheet. However, You need NOT do in each sheet when you can simply use ONE graph and indicate which sheet to graph. What is this for?

Reply | Quote

You only provide ONE sheet. However, You need NOT do in each sheet when you can simply use ONE graph and indicate which sheet to graph. What is this for?

Hi i have many sheets this is just an sample i give , all sheets having same format of data. On which needs to plot a graph

Reply | Quote

You could have a separate sheet and just use the data (with or without copying the data) from the desired sheet. Or, on the separate sheet, select the sheet and have a macro put the graphs on that desired sheet. Or have it automatic when the sheet is selected.and deleted when leaving sheet. OR??? The point is that you do not need to keep a graph on each sheet. Resource hog.

Reply | Quote

I have a data in all the sheets ( different data) , need to plot a graph in each sheet based on each sheet data.

note that every time when generate a report, new sheets auto created and the data retrieve on those sheets.I want to run a vb code to plot all the graph in each sheets.

i am reattaching the sample added two more sheets as a sample .

hope i understand well.

Reply | Quote

I don’t think you understood at all. See attached for what I am talking about.

40299-plots-SalesAidSoftware

Reply | Quote

Hi super !
Sorry i did not understand you…
I see your file you did excellent job for me…
Thank you it works for me..

Reply | Quote

Glad to help

Reply | Quote