Hi
I have 4 sheets so I have 4 different database
and 1 sheet5 for graph
I can generate data from sheet1 and click generate graph and it would graph it on sheet5
but how can use sheet5 to graph data from sheet2, sheet3 & sheet4
don't want to make another 3 separate graph sheet
Are the x axis for the different sheets the same? Is the data set up the same way on all sheets?
Just on impulse, select a data set, copy, click on your graph, paste special > new series. How'd that work?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi,
One way would be to construct a macro which prompted for a sheet name and then copied the data from that sheet to a common range. Use the common range as the source for the chart.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Data is all same, meaning same type of data
same number of cells same number of data hours
tags
just coming from different sheet
nevermind lol, I had it figured already when I started this project but forgot, I am copying data from all sheets 2 another sheet and graphing that sheet
thanks for help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks