Basic Chart setup (Never used a chart before)

rjwebgraphix

Well-known Member
Joined
May 25, 2010
Messages
590
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.
 
Last edited:
Ad cut off sheet, here it is. :(

Excel Workbook
ABCDGHIJ
1ERSA USED by:Puerto Rico STRM's******
2****CumulativeDaily- Over% of Forecast
3MonthDay24012457TotalGoal+ Under
4March1$1749.95*$1,749.95309.68-1,440.2718%
5*2**$1,749.95619.35-1,130.6018%
6PR Forecast3**$1,749.95929.03-820.9218%
7$9,600.004$2238.29*$3,988.241,238.71-2,749.5342%
8*5$740.21*$4,728.451,548.39-3,180.0649%
9*6$150.00*$4,878.451,858.06-3,020.3951%
10*7$383.33*$5,261.782,167.74-3,094.0455%
11*8$676.43*$5,938.212,477.42-3,460.7962%
12*9$518.34*$6,456.552,787.10-3,669.4567%
13*10**$6,456.553,096.77-3,359.7867%
14*11**$6,456.553,406.45-3,050.1067%
15*12$334.99*$6,791.543,716.13-3,075.4171%
16*13$85.75$24.30$6,901.594,025.81-2,875.7872%
17*14**$6,901.594,335.48-2,566.1172%
1815$119.00*$7,020.594,645.16-2,375.4373%
1916**$7,020.594,954.84-2,065.7573%
20*17**$7,020.595,264.52-1,756.0773%
21*18**$7,020.595,574.19-1,446.4073%
22Red Indicates that we are OVER budget19**$7,020.595,883.87-1,136.7273%
2320**$7,020.596,193.55-827.0473%
24*21**$7,020.596,503.23-517.3673%
25*22**$7,020.596,812.90-207.6973%
26Green Indicates we are within Budget23**$7,020.597,122.58101.9973%
2724**$7,020.597,432.26411.6773%
28*25**$7,020.597,741.94721.3573%
29*26**$7,020.598,051.611,031.0273%
30NOTE:27**$7,020.598,361.291,340.7073%
31Usage Calendar only displays STRM's that have usage. *STRM's without usage will be hidden.28**$7,020.598,670.971,650.3873%
3229**$7,020.598,980.651,960.0673%
3330**$7,020.599,290.322,269.7373%
3431**$7,020.599,600.002,579.4173%
35Total$6,996.29$24.30$7,020.59***
PR-Summary
 
Last edited:
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,226,857
Messages
6,193,379
Members
453,792
Latest member
Vic001

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top