How do I automatically plot different ranges of data in different.

G

Guest

I need to chart parameters that are a function of three variables in the 2002
version of Excel. I have used the x and y axis to represent 2 variables on an
'xy chart', but require an automatic method to represent the value of the
third variable. I have tried the 'bubble-plot', but cannot get sufficient
resolution between the data. Is their any way that I may plot the third
variable in different colours/shades, that automatically changes for
different ranges of the the third variable?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to plot bands in excel 1
Chart showing ranges of prices of different items? 3
Plot value at top of chart 1
Scatter plot 1
How do I put words as the Y axis values? 0
plot area inconsistent sizes with VBA 2
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
scaling of columns: same maximum height despite different ranges 2

Top