Replace y-axis values with graphic

[jmadsen]

Hi all,

I would like to present a Chart that has y-values from 0-10.
These values should be presented with graphic elements.
See attached jpg-file.

The Y-values should be fixed, start at 0 and end at 10 always.

The D-graphic should be placed between 0-1
The C1-C2 graphic should be placed between 1 - 4
The B1 - B3 graphic sholud be placed between 4 - 7
The A1 - A3 graphic should be placed between 7 - 10

All has to be done with a Macro in VBA.

Thanks for any help in advance.

Regards,

[mrice]

If you create your graphic elements as rectangle drawing objects with text you can use code like the following to align them to the axis.

Please Login or Register  to view this content.

[jmadsen]

Thanks for the reply.

To use Your code I have to manually draw the rectangles before executing the code?

I have a VBA Macro that do all the graph-work from scratch, so when I use Your code I
get an Error when the code tries to align the Rectangles. There are not Rectangles to work with.

Is there a way to get the Macro to draw the Rectangles as well?

Best regards,
Jørn

[jmadsen]

Hi,

I found this code, and it is working.

Please Login or Register  to view this content.

Thanks for showing me the direction.

Regards,