|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 26th, 2006, 07:11 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create a chart in Excel using data from two worksheets
I am trying to create a chart using data from two separate worksheets but it
will only allow me to use the information from one. 
|
|
#2
February 26th, 2006, 07:57 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I create a chart in Excel using data from two worksheets
Here is one way:
I made a chart from data in A10:B20 on sheet1 (A was the x-category data) I copied some cells from Sheet2, right clicked in chart area of chart and used Paste After the copy, I could have left clicked the chart and used Edit | Paste Special to specify more about the data I want to paste. Try it and come back with more questions. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "cdptuesdays" wrote in message ... I am trying to create a chart using data from two separate worksheets but it will only allow me to use the information from one.
|
|
#3
February 26th, 2006, 09:37 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I create a chart in Excel using data from two worksheets
I've posted some information about this topic:
http://peltiertech.com/Excel/ChartsH...iffSheets.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "cdptuesdays" wrote in message ... I am trying to create a chart using data from two separate worksheets but it will only allow me to use the information from one.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I number format the Data Table in an Excel Chart? | Chartsmalm | Charts and Charting | 3 | February 16th, 2006 02:06 PM |
| Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
| can you create a chart in excel with alphanumeric data? | Pugwyrm | Charts and Charting | 3 | June 6th, 2005 07:10 PM |
| How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
| Excel Worksheets | Richard | General Discussion | 2 | July 8th, 2004 04:34 AM |
Linear Mode
