If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Showing a different set of data in a chart
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 |
#2
|
|||
|
|||
Showing a different set of data in a chart
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 |
#3
|
|||
|
|||
Showing a different set of data in a chart
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 |
#4
|
|||
|
|||
Showing a different set of data in a chart
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 |
#5
|
|||
|
|||
Showing a different set of data in a chart
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 |
#6
|
|||
|
|||
Showing a different set of data in a chart
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 |
#7
|
|||
|
|||
Showing a different set of data in a chart
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 |
Thread Tools | |
Display Modes | |
|
|