scaling my chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hey all,
first of all, i'm not sure if this is the best forum for the Office Web
Components so if there are suggestion please advise.

now, my question is i have a bar chart that only has 2 bars and one bar's
value is thousands more than the other so the chart shows one really tall bar
and the other bar you can hardly see.

is there a way to scale this so that the smaller bar shows up more?

thanks,
rodchar
 
but wouldn't that make the smaller bar even smaller? sorry if i'm not
understanding you correctly.

Eliyahu Goldin said:
Why don't you scale the values yourself in the code by just dividing by 1000
or something like that?

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net


rodchar said:
hey all,
first of all, i'm not sure if this is the best forum for the Office Web
Components so if there are suggestion please advise.

now, my question is i have a bar chart that only has 2 bars and one bar's
value is thousands more than the other so the chart shows one really tall
bar
and the other bar you can hardly see.

is there a way to scale this so that the smaller bar shows up more?

thanks,
rodchar
Click to expand...
Click to expand...
 
Depending on the nature of the data you can choose a function that will do a
better scaling job, perhaps using logarithms. The point is that it is you
who knows better how to scale your data and you should be able to do it
easily before passing the values for charting.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net


rodchar said:
but wouldn't that make the smaller bar even smaller? sorry if i'm not
understanding you correctly.

Eliyahu Goldin said:
Why don't you scale the values yourself in the code by just dividing by
1000
or something like that?

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net


rodchar said:
hey all,
first of all, i'm not sure if this is the best forum for the Office Web
Components so if there are suggestion please advise.

now, my question is i have a bar chart that only has 2 bars and one
bar's
value is thousands more than the other so the chart shows one really
tall
bar
and the other bar you can hardly see.

is there a way to scale this so that the smaller bar shows up more?

thanks,
rodchar
Click to expand...
Click to expand...
Click to expand...
 
hey all,
first of all, i'm not sure if this is the best forum for the Office Web
Components so if there are suggestion please advise.

now, my question is i have a bar chart that only has 2 bars and one bar's
value is thousands more than the other so the chart shows one really tall bar
and the other bar you can hardly see.

is there a way to scale this so that the smaller bar shows up more?

thanks,
rodchar
Click to expand...

If i were you I'd use a logarithmic scale to draw the charts. Get the log
of the values before plotting the chart and then plot those instead of the
actual values
 
Back
Top