Creating a Unique Chart - New User - Please help!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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/
_______
 
Back
Top