HELP! HOW TO COMBINE CHARTS IN MS.EXCEL
 

Hi. Im a business student but im taking computing class as it is
compulsary. i have an assignment to combine 2 charts. i have 2 data
sets ( sales 2007 and sales 2008). The sales 2007 is in sheet 1, while
sales 2008 in sheet 2. i have to make 1 chart showing a comparison
between those two figures in sheet 3. So far, i can only create them
seperately, therefore please help me with this problem.

HELP! HOW TO COMBINE CHARTS IN MS.EXCEL
 

Create a chart with one set of data. Copy the other set of data, select the
chart, and use Paste Special to add the data as a new series.

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


wrote in message
...
Hi. Im a business student but im taking computing class as it is
compulsary. i have an assignment to combine 2 charts. i have 2 data
sets ( sales 2007 and sales 2008). The sales 2007 is in sheet 1, while
sales 2008 in sheet 2. i have to make 1 chart showing a comparison
between those two figures in sheet 3. So far, i can only create them
seperately, therefore please help me with this problem.