scaling my chart

[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

 

[Eliyahu Goldin]

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

 

[Guest]

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

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

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

 

[Eliyahu Goldin]

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

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

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

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

 

[Rad [Visual C# MVP]]

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

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