HELP! HOW TO COMBINE CHARTS IN MS.EXCEL

S

shya_118

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.
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlighting Like Names in a Column 3
PLEASE HELP! Return a Value Using Multiple Sources 4
Help with a formula (Multiple lines to sum and return if) 2
Entering New Weekly Data causes Summary Page to Update..How? 2
How do I Return a Value Using Multiple Criteria? 1
CHART HELP Percent of Increase 2
Combining same data in multiple rows 4
Combine bar chart with stacked chart 1

Top