Tchart with 5 series and 5 different Y-scale

I need to draw a chart with 5 series, in which each one has different Y scale, How is possible handle all ???
gianlucaAsked:
Who is Participating?
 
BoomersConnect With a Mentor Commented:
Hi gianluca,

  The vtchart (in the ActiveX section) will allow you to set 2 differents scales for the Y value. You just need to set your series to attach to the second serie by doing the following:

1. Drop the object on a Form.
2. With the wizard, select Gallery, Style, Layout.
3. When you're on the Axes page, set a label to the Secondary Y2.
4. Now you need to set your serie to tight to the second scale by right-click properties, series, series...
5. Select one of the series then toggle the "Plot On 2nd Axis".

I saw some more chart on the web but they cost money. Some of them seems to have more then two scales:
http://www.icsgmbh.de/english/datenanalyse/trvpg3.htm

This could be an option for you.

Good luck!
0
 
BoomersCommented:
Do you need to see each Y scale?

If not you can always devide all y information by a common factor.

EX:
MAX    DEVIDE Y BY
100    1
200    2
250    2.5
134    134 / 100

Good luck!
0
 
gianlucaAuthor Commented:
Yes, I already think about this solution. I can do it because I need to change Y scale according to a button selection.... but is this the ONLY possible solution ????
0
 
gianlucaAuthor Commented:
OK, understand.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.