scatter chart -- x-axis

[arif_qaisar]

Hi,

I am using Xml and vbscript to create a scatter chart. I have got the chart working with correct y axis but i want to design the x axis which is displayed as below:

strXML = "<chart subcaption='MSCI Europe index' numDivLines='5' rotateNames='1' showLegend='1' showNames='1' decimals='1' useRoundEdges='1' bgcolor='ffffff'>"

 

There are loads of figures for both x and y axis. I do not want to display all the figures.

I have worked it out for the y axis as shown above which I assume is numDivLine='5' in the above code.

Can i simplify the figures on the x-axis so that it shows me a few 'readable' figures?

Regards,

Arif Qaisar

[Pallav]

Hi,

 

 

 

For each category element there is an attribute showLabel='0' which can hide the label for that category.