Graph and Series Axis

[mcalex]

Hi there.

I have a ppt procedure which creates a 3d Area chart using Ms-Graph.
There are two series in the graph and for some reason, one of the
series is given a title (taken from the header column on the
datasheet), and I can't get rid of it. When I double-click the chart
in ppt, and then hover the mouse over the text, the tooltip/hint is
'Series Axis', but code i've added (see below) to remove all the
series axis titles does nothing.
For Each a In oGraph.Axes
a.HasTitle = False
Next a

Interestingly, when I change the .HasTitle to true, the chart is
created with 3 extra titles on it, which according to their tool tips
are: a 'Value Axis Title', a 'Category Axis Title', and a 'Series Axis
Title' (note, not a Series Axis). The interesting bit is when i click
on the text of the Series Axis, and hit delete, both it and the new
Series Axis Title disappear.

I've tried just inserting whitespace in the header column to get rid
of this title, but then I can't produce a legend for the chart, which
I do want. Any suggestions? I hope this all makes sense, I was going
to post an image to clear up the 'series axis' vs 'series axis title',
but was worried about bandwidth. If I should do this, let me know.

Tia
alex

 

[Andy Pope]

Hi alex,

Maybe the label you can see is not the title but the tick labels.
Try this revision to your code.

For Each a In oGraph.Axes
a.TickLabelPosition = -4142 ' xlTickLabelPositionNone
Next

Cheers
Andy

 

[mcalex]

Thanks Andy, that was it.

Hi alex,

Maybe the label you can see is not the title but the tick labels.
Try this revision to your code.

For Each a In oGraph.Axes
a.TickLabelPosition = -4142 ' xlTickLabelPositionNone
Next

Cheers
Andy