Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 17th 08, 11:06 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 7
Default Superimpose one chart on another

How do I superimpose one chart onto another so that I can see all of the data
in both charts? One is a scatter graph and the other is a line graph using
different sets of data in each graph.

  #2   Report Post  
Old October 18th 08, 01:41 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
Default Superimpose one chart on another

Hi,

Well you can superimpose two chart but most of us would suggest that you
chart both sets of data on the xy scatter and then for the one you want to be
a line, you select its series and choose Chart, Chart Type and change it to
an xy scatter with a line.

If you want to supperimpose to charts put one over the other and right click
the plot area, choose Format Plot area, and on the Patterns tab set the Fill
to None. Then Right click the Chart Area and do the same thing.

--
Thanks,
Shane Devenshire


"Kirsten" wrote:

How do I superimpose one chart onto another so that I can see all of the data
in both charts? One is a scatter graph and the other is a line graph using
different sets of data in each graph.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do you superimpose a graph onto another? drisker Charts and Charting in Excel 1 March 12th 08 12:59 PM
how do i superimpose graphs with different scales? Omwami Mugishagwe Excel Discussion (Misc queries) 2 May 15th 07 04:22 PM
on bar graph, how to superimpose line of average values over bars Kavitha Charts and Charting in Excel 3 August 23rd 06 08:59 AM
superimpose type yfnw Excel Discussion (Misc queries) 1 September 19th 05 11:52 PM
How can I superimpose one chart over the other? sas1950 Charts and Charting in Excel 1 August 17th 05 04:49 AM


All times are GMT +1. The time now is 09:25 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017