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.
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: