I want to create a chart using data from two or more worksheets but so far the paperclip is giving me the run-around...any suggestions?

Create the chart on one worksheet using the data from that sheet.

Then, switch to the 2nd worksheet and copy the data of interest.

Switch back to the 1st worksheet. Select the chart, then Edit | Paste
Special... In the resulting dialog box, indicate desired attributes
(data in columns, new series, etc.)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <2A79FEEF-2ECD-4332-B26B-(E-Mail Removed)>,
(E-Mail Removed) says...
> I want to create a chart using data from two or more worksheets but so far the paperclip is giving me the run-around...any suggestions?
>

Paste Special is on the Edit menu. It works for chart sheets and charts
embedded on worksheets. If your menus seem short, right click on the
menu bar, and select Customize from the bottom. On the Options tab,
check the Always Show Full Menus box. For some reason, they think it's
helpful to hide menu items if you haven't used them for a while.

If you have a set of points made up of data from one sheet, and you want
to use data from another sheet or workbook instead, choose Source Data
from the Chart menu, click on the Series tab, and select the series in
the list. Then for each of the data entry boxes, you can change the
contents to the other data. Clear the box, then use the sheet tabs below
to select a different sheet, or the Windows menu to select a different
open workbook (yes, these work even with the dialog box open), and
select the data with your mouse.

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

Seshmut wrote:

> Unfortunately this didn't work...the charts themselves have already
> been made with the data from the first sheet (the data is only now
> having to be seperated into many sheets) and is not displayed on a
> worksheet, I tried to find the command for "Paste Special" everywhere
> on the chart page and was unable to locate it....the option just
> isn't there
>
>
>
> ----- Tushar Mehta wrote: -----
>
> Create the chart on one worksheet using the data from that sheet.
>
> Then, switch to the 2nd worksheet and copy the data of interest.
>
> Switch back to the 1st worksheet. Select the chart, then Edit |
> Paste Special... In the resulting dialog box, indicate desired
> attributes (data in columns, new series, etc.)
>
> -- Regards,
>
> Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins,
> tutorials Custom MS Office productivity solutions
>
> In article <2A79FEEF-2ECD-4332-B26B-(E-Mail Removed)>,
> (E-Mail Removed) says...
>> I want to create a chart using data from two or more worksheets but
>> so far the paperclip is giving me the run-around...any suggestions?
>>
>>