Inputting Source Data - help please
 

I am creating a custom combination chart to display sales data. Bars
along the x axis will display actaul sales figures and a line graph
will dispay projected sales.

I am new to this and am not sure how to enter the data. I have the
data on a separate worksheet as you see below (but lined up better).
If anyone has suggested regarding how to enter the data formula, I
would appreciate it.

Apr May Jun Jul Aug Sep Oct Nov Dec Total
Actual 6
Projected 2,836 560 800 1,936 8,112 5,412 6,656 3,568 29,880


Thanks,
Ali :) :confused:


--
foredis
------------------------------------------------------------------------
foredis's Profile: http://www.excelforum.com/member.php...o&userid=24471
View this thread: http://www.excelforum.com/showthread...hreadid=380711

Create a bar chart for using both the projected and actual sales figures.
Once you've done that, select the series for the projected sales and right
click on the series. You can change the chart type to LINE at this time.

With the data you gave, the actual bar is negligible, so you may need to
change the projected sales to use a secondary axis.

"foredis" wrote:


I am creating a custom combination chart to display sales data. Bars
along the x axis will display actaul sales figures and a line graph
will dispay projected sales.

I am new to this and am not sure how to enter the data. I have the
data on a separate worksheet as you see below (but lined up better).
If anyone has suggested regarding how to enter the data formula, I
would appreciate it.

Apr May Jun Jul Aug Sep Oct Nov Dec Total
Actual 6
Projected 2,836 560 800 1,936 8,112 5,412 6,656 3,568 29,880


Thanks,
Ali :) :confused:


--
foredis
------------------------------------------------------------------------
foredis's Profile: http://www.excelforum.com/member.php...o&userid=24471
View this thread: http://www.excelforum.com/showthread...hreadid=380711