How to graph columns from different worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried to use the hold-CTRL method to select columns on different worksheets
and graph them, but it doesn't work.
Any ideas?
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying worksheet including graphs to new worksheet 9
Access Combination Chart Types Access 2010 0
Graph changes to blank!! 5
Making 1 Pivot chart from 3 different worksheets. 4
Copy column from different sheets and plot a graph 3
Graphing data from multiple worksheets in same workbook 1
Insert multiple .dat files into one pdf without losing color of their graphs 0
Print Macro Help 1

Back
Top