I need to have a stacked column chart show the percentage (range 1 - 100%) of each data point (Customer 1 and 2) within each of the represented fiscal years. Attached is a sample workbook containing my chart work thus far and the sample data.
Ideally, I would like the percentages positioned within their respective column for each of the five years. I've shown this in the first fiscal year by inserting a drawn text box and keying the respective percentages. Obviously, I want the percentages tied to the source data for when that data changes. I thought I could accomplish this by adding a secondary y-axis with a scale of 1 - 100%; however, I can't get that technique to work. I've been able to add the total of Customer 1 and 2s sales for each fiscal year, represented by the data series over the stacked columns, and charting them as a line chart and using None for the Line and Marker options. These fiscal year total sales should remain, in addition to the respective percentages.
Also, for some reason my x-axis scale is now represented by dates of 01/01/2005, 01/01/2006, etc. However, the dates should be, as shown in the Data worksheet and the chart Data Table, 05/31/2005, 05/31/2006, etc. I've changed the axis scale with no success.
Thank you in advance for any input and suggestions,
John
Bookmarks