Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to graph columns from different worksheets
I tried to use the hold-CTRL method to select columns on different worksheets
and graph them, but it doesn't work. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to graph columns from different worksheets
Piano man,
In step 2 of the chart wizard, go to the Series tab. There you can select (and create, if necessary) each series, and assign it to the columns of whatever sheet you want. Select the series you want, then put the cursor in the "Values" box, then switch to the sheet, select the cells, and that's it. Bob's your uncle. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "NavyPianoMan" wrote in message ... I tried to use the hold-CTRL method to select columns on different worksheets and graph them, but it doesn't work. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graph data from multiple worksheets | Charts and Charting in Excel | |||
How do I create an overall graph from Multiple worksheets? | Excel Worksheet Functions | |||
How do I copy columns between worksheets if the columns don't matc | Excel Worksheet Functions | |||
How I can use the same graph in multiple worksheets? | Excel Worksheet Functions | |||
How do I combine two worksheets into one graph | Charts and Charting in Excel |