| Home |
| Search |
| Today's Posts |
|
#1
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3-d referneces in chart series values | Charts and Charting in Excel | |||
| Histograms chart with two series, each with different X values | Excel Discussion (Misc queries) | |||
| Using offset in series values of a chart | Charts and Charting in Excel | |||
| chart x-axis values appear as a series | Charts and Charting in Excel | |||
| Chart -- How to chart 65536 values in 1 series? | About this forum | |||
Linear Mode
