ExcelBanter - Creating charts

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Creating charts (https://www.excelbanter.com/excel-discussion-misc-queries/204325-creating-charts.html)

Novice

Creating charts

Can I create a chart using data from two worksheets or workbooks?

Jon Peltier

Creating charts

Probably. See this article for details:
http://peltiertech.com/Excel/ChartsH...iffSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

"Novice" wrote in message
...
Can I create a chart using data from two worksheets or workbooks?

Bernard Liengme

Creating charts

It is best to have the data in one place.
But that place can reference other worksheets as in
=Sheet3!B4
=[JumpTwo.xls]Sheet1!$L$3

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Novice" wrote in message
...
Can I create a chart using data from two worksheets or workbooks?

All times are GMT +1. The time now is 01:48 PM.