Showing a different set of data in a chart
in [Charts]
|
From: trip_to_tokyo on 22 Feb 2010 14:49 OK, sorry can't help as work in 2007. "Stuart H" wrote: > Oops sorry forgot that Exel 2003 > > "trip_to_tokyo" wrote: > > > Sorry, Stuart, which EXCEL version please? > > > > Tks. > > > > "Stuart H" wrote: > > > > > Hi Trip_to_tokyo, > > > > > > I have a stacked column chart with hours used running up the side and unit > > > number across the bottom, hours used ranges from 0 to 250 hours, I would like > > > to show % complete but when I put in a new series of data it changes my axis > > > values to % instead of a plain number? Any help greatly appreciated. > > > > > > Stuart > > > > > > "trip_to_tokyo" wrote: > > > > > > > Stuart, which version of EXCEL please? > > > > > > > > What type of chart do you have? A column chart? > > > > > > > > What have you got running up the left hand side of the graph (hours worked?) > > > > > > > > What's on the horizontal axis? > > > > > > > > Where do you want the percentages (on the right hand side of the graph > > > > running up the vertical axis?). > > > > > > > > > > > > > > > > > > > > > > > > "Stuart H" wrote: > > > > > > > > > I have a chart showing numbers between 50 & 250 for hours used, I also want > > > > > to add in % complete but only show the data labels, I want the data labels > > > > > above the columns for hours used, does anyone have any suggestions as to how > > > > > to do this please. Thanks in advance > > > > > > > > > > Stuart H
From: trip_to_tokyo on 22 Feb 2010 15:48
Stuart, I have just run up what I think you are doing in 2007 and, as far as I can see, what you are seeing is correct. Let me explain:- 1. In A1 to A5 I have:- Title Unit 1 Unit 2 Unit 3 Unit 4 These correctly get loaded to horizontal axis. 2. In B1 to B5 I have:- January Hours 50 100 150 200 3. In C1 to C5 I have:- February Hours 100 150 200 250 4. In D1 to D5 I have:- March Hours 75 125 175 225 Highlight all of the above data A1 to D5 and set up a 100% Stacked Column Chart. 5. If I now look at the chart I see Unit 1 Unit 2 Unit 3 and Unit 4 along the horizontal axis. 6. On the left hand Y (Value Axis) I have percentages running from 0% to 100% (and this is correct). 7. My 100% Stacked Column for Unit 1 shows me (running up the column from bottom to top):- 50 Blue 100 Maroon 75 Green These are the correct values pulled from the underlying data. The sum of these values is 225. Expressing each individually as a percentage of 225 I get:- 22% Blue 44% Maroon 33% Green - and these percentages are correctly reflected on the Vertical Axis. As far as I can see this gives you what you want. 8. I will explain the second column that I see on my chart for the sake of clarity. My 100% Stacked Column for Unit 2 shows me (running up the column from bottom to top):- 100 Blue 150 Maroon 125 Green These are the correct values pulled from the underlying data. The sum of these values is 375. Expressing each individually as a percentage of 375 I get:- 27% Blue 40% Maroon 33% Green - and these percentages are correctly reflected on the Vertical Axis. Hope the above helps. If it does please hit Yes. Thanks. This "Stuart H" wrote: > Oops sorry forgot that Exel 2003 > > "trip_to_tokyo" wrote: > > > Sorry, Stuart, which EXCEL version please? > > > > Tks. > > > > "Stuart H" wrote: > > > > > Hi Trip_to_tokyo, > > > > > > I have a stacked column chart with hours used running up the side and unit > > > number across the bottom, hours used ranges from 0 to 250 hours, I would like > > > to show % complete but when I put in a new series of data it changes my axis > > > values to % instead of a plain number? Any help greatly appreciated. > > > > > > Stuart > > > > > > "trip_to_tokyo" wrote: > > > > > > > Stuart, which version of EXCEL please? > > > > > > > > What type of chart do you have? A column chart? > > > > > > > > What have you got running up the left hand side of the graph (hours worked?) > > > > > > > > What's on the horizontal axis? > > > > > > > > Where do you want the percentages (on the right hand side of the graph > > > > running up the vertical axis?). > > > > > > > > > > > > > > > > > > > > > > > > "Stuart H" wrote: > > > > > > > > > I have a chart showing numbers between 50 & 250 for hours used, I also want > > > > > to add in % complete but only show the data labels, I want the data labels > > > > > above the columns for hours used, does anyone have any suggestions as to how > > > > > to do this please. Thanks in advance > > > > > > > > > > Stuart H |