View Single Post
  #5   Report Post  
Pim
 
Posts: n/a
Default


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