Graph - point on line?

unc2plo · Mar 19th, 2002, 07:26 AM

I want to chart 2 types of sales by week. I want the main line to be regular sales, and to have a "point" on the same line when there was a newspaper ad. I have the sales broken down into to rows - row 1 is "total sales" and row 2 is "media sales".

Can this be done?

Thanks,
David

Mark W. · Mar 19th, 2002, 07:51 AM

Yes. Provide some sample data.

[ This Message was edited by: Mark W. on 2002-03-19 06:51 ]

unc2plo · Mar 19th, 2002, 08:03 AM

WEEK 9 WK 5 10 WK 1 10 WK 2
total sales 2644 504 1172
media sales 899 0 191
reg sales 1745 504 981

Hope this helps. I f not I can email you a spreadsheet.

Thanks,
David

Mark W. · Mar 19th, 2002, 11:24 AM

Okay, so say cells A1:D4 contain...

{"WEEK","9 WK 5","10 WK 1","10 WK 2"
;"total sales",2644,504,1172
;"media sales",899,0,191
;"reg sales",1745,504,981}

How do I know when there was a newpaper ad?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 07:26 AM	#1
unc2plo Board Regular Join Date: Mar 2002 Location: Minneapolis, MN Posts: 148	I want to chart 2 types of sales by week. I want the main line to be regular sales, and to have a "point" on the same line when there was a newspaper ad. I have the sales broken down into to rows - row 1 is "total sales" and row 2 is "media sales". Can this be done? Thanks, David

Mar 19th, 2002, 07:51 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Yes. Provide some sample data. [ This Message was edited by: Mark W. on 2002-03-19 06:51 ]

Mar 19th, 2002, 08:03 AM	#3
unc2plo Board Regular Join Date: Mar 2002 Location: Minneapolis, MN Posts: 148	WEEK 9 WK 5 10 WK 1 10 WK 2 total sales 2644 504 1172 media sales 899 0 191 reg sales 1745 504 981 Hope this helps. I f not I can email you a spreadsheet. Thanks, David

Mar 19th, 2002, 11:24 AM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Okay, so say cells A1:D4 contain... {"WEEK","9 WK 5","10 WK 1","10 WK 2" ;"total sales",2644,504,1172 ;"media sales",899,0,191 ;"reg sales",1745,504,981} How do I know when there was a newpaper ad?