Good afternoon,
I'm trying to create a chart in Excel 2003 (I have Excel 2007 on my computer, but our shared company server uses 2003) and I'm hoping you can help. I've seen this chart in a presentation and have a PDF copy of the chart, but I'm unsure how to show you an example so I'll try to describe it as best I can.
This chart was labelled as a "Business Unit Range Success Rate Report". On the x-axis we have the months Jan - Dec and on the y-axis we have underlying sales growth for the business unit in question.
There are three distinct pieces to this chart. The first is the forecasted range that we anticipate the sales growth to fall into for that specific month. This is represented by a bar that will span a few percentage points each month (eg. Historically we can expect February year over year sales growth of between 3-6% while in November we can expect year over year sales growth of 0.5-1.5%). This first piece would look like a waterfall chart.
The second aspect of the chart would be to place a forecast point (somewhere within the range bar that we've created above) that would represent the business target for each month.
The third aspect would then be to overlay the actuals in a line graph on top of the chart we've created to hopefully ensure the actual results are falling into our anticipated range.
Again, it would be easier if I could attach a snapshot pulled from the PDF file, but hopefully this description will suffice.
Thank you so much for your time and I welcome any and all suggestions. I'm very new here, but always interested in learning about new and dynamic ways of using Excel.
I'm trying to create a chart in Excel 2003 (I have Excel 2007 on my computer, but our shared company server uses 2003) and I'm hoping you can help. I've seen this chart in a presentation and have a PDF copy of the chart, but I'm unsure how to show you an example so I'll try to describe it as best I can.
This chart was labelled as a "Business Unit Range Success Rate Report". On the x-axis we have the months Jan - Dec and on the y-axis we have underlying sales growth for the business unit in question.
There are three distinct pieces to this chart. The first is the forecasted range that we anticipate the sales growth to fall into for that specific month. This is represented by a bar that will span a few percentage points each month (eg. Historically we can expect February year over year sales growth of between 3-6% while in November we can expect year over year sales growth of 0.5-1.5%). This first piece would look like a waterfall chart.
The second aspect of the chart would be to place a forecast point (somewhere within the range bar that we've created above) that would represent the business target for each month.
The third aspect would then be to overlay the actuals in a line graph on top of the chart we've created to hopefully ensure the actual results are falling into our anticipated range.
Again, it would be easier if I could attach a snapshot pulled from the PDF file, but hopefully this description will suffice.
Thank you so much for your time and I welcome any and all suggestions. I'm very new here, but always interested in learning about new and dynamic ways of using Excel.
