UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Help with Charting In Excel 2003    
 
   
cleverchap
post Jan 18 2007, 06:50 AM
Post #1

UtterAccess Member
Posts: 28
From: London, UK
Hi guys,

I am trying to combine two charts into one (see chart1 and chart2), using the values in the Data Worksheet.
Please advise on what chart, or method to use to combine both?

Many Many thanks
chris
Attached File(s)
Attached File  utteraccess.zip ( 2.76K ) Number of downloads: 6
 
Go to the top of the page
 
+
carolel
post Jan 18 2007, 07:22 AM
Post #2

UtterAccess Guru
Posts: 662
From: Devon, UK
Hello Chris

Plot all 4 series on one graph (stacked bar). Select one of the series you want as a line, so that all the points are highlighted. Right click and select Chart Type, then you can select the line graph. Repeat for the second series you want as a line.

Carole
Go to the top of the page
 
+
cleverchap
post Jan 18 2007, 07:43 AM
Post #3

UtterAccess Member
Posts: 28
From: London, UK
You are a legend, thank you very much (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)

chris (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)
Go to the top of the page
 
+
carolel
post Jan 18 2007, 08:09 AM
Post #4

UtterAccess Guru
Posts: 662
From: Devon, UK
You are way too kind (IMG:http://www.utteraccess.com/forum/style_emoticons/default/blush.gif) and very welcome

Carole
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 07:35 AM