|
| 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
March 22nd, 2009, 12:06 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
Add values to a series in a chart
How do I add other values to the same series on a chart. The other values are
on seperate worksheets. Example: this is what I have =Sheet1!$B$34 and I want to also add to this series =Sheet2!$B$3. I have tried =Sheet1!$B$34 and Sheet2!$B$3 but get an error. 
|
|
#2
March 22nd, 2009, 12:02 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Add values to a series in a chart
Hi,
Have a read of Jon's information on charting from different sheets. http://peltiertech.com/Excel/ChartsH...iffSheets.html Cheers Andy Marty wrote: How do I add other values to the same series on a chart. The other values are on seperate worksheets. Example: this is what I have =Sheet1!$B$34 and I want to also add to this series =Sheet2!$B$3. I have tried =Sheet1!$B$34 and Sheet2!$B$3 but get an error. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
