Showing a different set of data in a chart
in [Charts]
|
From: Stuart H Stuart on 22 Feb 2010 14:13 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 14:22 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: Stuart H on 22 Feb 2010 14:29 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 14:36 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: Stuart H on 22 Feb 2010 14:46
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 |