Hi Ann
hm...
well, try this as an example and see if it looks right-
if not, indicate what's off and we'll go from the
(that way you don't have to go through the pain of formatting your
data-
then finding out this isn't quite right)
type in into an new sheet:
cell a1:Month
B1: Total Cookies
C1:Total Candy
A2: June
B2:500
C2: 750
A3: July
B3: 250
C3: 350
A4: August
B4: 450
C4: 500
highlight the cells in A1:C4 and start the chart wizard-
and take it from the first post.
If you're looking for an easy way to separate the data, that's a whole
new ball game
;)
--
Pim
------------------------------------------------------------------------
Pim's Profile:
http://www.excelforum.com/member.php...o&userid=27565
View this thread:
http://www.excelforum.com/showthread...hreadid=471114