3rd axis chart

  • Thread starter Thread starter jaom
  • Start date Start date
J

jaom

hello-
i would like to create a complicated chart, with what i
believe would be 3 axis'. the x axis has 5 categories. the
y axis also has 5 categories, but they are split into two
parts, a percentage and a total number. i want the graph to
illustrate the percentage, and show the value for the
number, but i haven't been able to make this work.

finally i want to average the percentages from each
category on the x axis and create 5 separate lines that
illustrate each of those averages on the graph.

i'm using NT, excel 2000

any help would be much appreciated.

thanks!
 
Excel does have a 3d chart option but it is like a Line chart not an XY
chart.
Bernard
 
hello-
i would like to create a complicated chart, with what i
believe would be 3 axis'. the x axis has 5 categories. the
y axis also has 5 categories, but they are split into two
parts, a percentage and a total number. i want the graph to
illustrate the percentage, and show the value for the
number, but i haven't been able to make this work.

finally i want to average the percentages from each
category on the x axis and create 5 separate lines that
illustrate each of those averages on the graph.
Click to expand...

While I don't completely follow your question, I do know that it is
possible to put a 3rd axis on a line chart. See
http://www.geocities.com/jonpeltier/Excel/Charts/TertiaryAxis.html for
details.
 
Back
Top