Add data to a graph from multiple sheets.

BostonMike · #1 06-30-2009, 04:26 PM

I have an excel workbook open. It has 4 sheets to it. There are various points of data on the first three sheets that I want to add data to the graph on the fourth sheet. I want to add the data to the x axis. I right click the x axis, select data source, edit, then I go to sheet1. I hold the ctrl key and select the cell I want, no problem but it seems I can't add from multiple sheets. Can someone help me figure this out. It would be much appreciated.

Andy Pope · #2 07-01-2009, 05:30 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

The data for any one series must be on a single sheet.
More info here
http://peltiertech.com/Excel/ChartsH...iffSheets.html

Welcome to the Excel Forum

Forum Statistics