Basic Chart setup (Never used a chart before)

[rjwebgraphix]

I have never used a chart before and figured the chart wizard should be simple. Even read through some articles such as Excel Charts Tutorial

Unfortunantly, it seems that what I'm trying to do for a chart doesn't seem to be wizard friendly..... or I really just don't know what I'm doing.

Below is a condensed version of the data. Store numbers on the top. Days of month to the left. The spreadsheet well covers that. What I am trying to chart is the individual store's spending in relation to the forecasted budget. In other words, if the forecast budget (as in the example) is $9600. What percentage of the total budget is being taken up by each individual store. As you can see with the dummy data. Store 2401 is killing the budget, so if this trend continues, that store will be way over budget, whereas store 2457 has spent a minimal amount in relation to the total budget.

All the data is right there in front of me, but actually charting it the way I need to doesn't seem to work.

The best I got was it showing me what stores spent on each day, which isn't needed because we see that plainly the way the sheet is laid out.

Since I've never done a chart before, how to get what I'm looking to do is elluding me.

Any Assistance in getting this to a chart would be helpful.... or at least a point in the right direction.

 

[rjwebgraphix]

Ad cut off sheet, here it is.

Excel Workbook
	A	B	C	D	G	H	I	J
1	ERSA USED by:	Puerto Rico STRM's	*	*	*	*	*	*
2	*	*	*	*	Cumulative	Daily	- Over	% of Forecast
3	Month	Day	2401	2457	Total	Goal	+ Under
4	March	1	$1749.95	*	$1,749.95	309.68	-1,440.27	18%
5	*	2	*	*	$1,749.95	619.35	-1,130.60	18%
6	PR Forecast	3	*	*	$1,749.95	929.03	-820.92	18%
7	$9,600.00	4	$2238.29	*	$3,988.24	1,238.71	-2,749.53	42%
8	*	5	$740.21	*	$4,728.45	1,548.39	-3,180.06	49%
9	*	6	$150.00	*	$4,878.45	1,858.06	-3,020.39	51%
10	*	7	$383.33	*	$5,261.78	2,167.74	-3,094.04	55%
11	*	8	$676.43	*	$5,938.21	2,477.42	-3,460.79	62%
12	*	9	$518.34	*	$6,456.55	2,787.10	-3,669.45	67%
13	*	10	*	*	$6,456.55	3,096.77	-3,359.78	67%
14	*	11	*	*	$6,456.55	3,406.45	-3,050.10	67%
15	*	12	$334.99	*	$6,791.54	3,716.13	-3,075.41	71%
16	*	13	$85.75	$24.30	$6,901.59	4,025.81	-2,875.78	72%
17	*	14	*	*	$6,901.59	4,335.48	-2,566.11	72%
18		15	$119.00	*	$7,020.59	4,645.16	-2,375.43	73%
19		16	*	*	$7,020.59	4,954.84	-2,065.75	73%
20	*	17	*	*	$7,020.59	5,264.52	-1,756.07	73%
21	*	18	*	*	$7,020.59	5,574.19	-1,446.40	73%
22	Red Indicates that we are OVER budget	19	*	*	$7,020.59	5,883.87	-1,136.72	73%
23		20	*	*	$7,020.59	6,193.55	-827.04	73%
24	*	21	*	*	$7,020.59	6,503.23	-517.36	73%
25	*	22	*	*	$7,020.59	6,812.90	-207.69	73%
26	Green Indicates we are within Budget	23	*	*	$7,020.59	7,122.58	101.99	73%
27		24	*	*	$7,020.59	7,432.26	411.67	73%
28	*	25	*	*	$7,020.59	7,741.94	721.35	73%
29	*	26	*	*	$7,020.59	8,051.61	1,031.02	73%
30	NOTE:	27	*	*	$7,020.59	8,361.29	1,340.70	73%
31	Usage Calendar only displays STRM's that have usage. *STRM's without usage will be hidden.	28	*	*	$7,020.59	8,670.97	1,650.38	73%
32		29	*	*	$7,020.59	8,980.65	1,960.06	73%
33		30	*	*	$7,020.59	9,290.32	2,269.73	73%
34		31	*	*	$7,020.59	9,600.00	2,579.41	73%
35		Total	$6,996.29	$24.30	$7,020.59	*	*	*
PR-Summary

 

[rjwebgraphix]

I was able to get a chart to work, but not the chart I'm looking for.

For now,

In the series tab, I have one series setup

Values: ='PR-Summary'!$C$35:$D$35
Category (x) axis labels: ='PR-Summary'!$C$3:$D$3

but this just shows what I already see in the spreadsheet. I need a Chart that shows it's relation to the budget forecast (A7) and show the percentage of the total budget used for each store. Not sure how to get a chart to do that.

 

[rjwebgraphix]

Nevermind, I think I'm going to scrap the chart idea.

I think I got it to work by creating an additional two rows of data to the above sheet. Row 36 containing the actual percentages and Row 37 containing the static value of what A7 is.

Using those and setting up 3 different Series on a single axis based on the A7 forecast, I got the Forecast, Amount used and percentage of the forecast (overlap at 100%), it looks right, but when adding in all of the other stores it just jammed everything together so tight that nothing made sense unless I blew the chart up so big that it wouldn't fit on the screen.

Seeing as I had to put more calculated data in anyway and the chart couldn't just calculate it for me (or I just don't know how to get it to do it), I might as well just make it visible and it becomes self-serving and no need for the chart.

Thanks anyway.