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
|