Moving X-Axis Value Labels to Top of chart OWC11

M

mcbensch

I need to move the X-Axis Values (Labels) from the default bottom of
the chart to the top of the chart for a chChartTypeBarClustered
charttype.

In excel you can do this by right clicking on the y-axis then clicking
Format Axis>Scale> and checking Categories in reverse order.

I'm sure this is very intuitive but I'm only about a day into the OWC
stuff..

Thanks in advance,

mcbensch
 
P

Penka

On the toolbar, click Comands and Options, under General tab select the
x-axis, then click the Format tab and change the Position of the axis from
bottom to top.

Regards,
 
M

mcbensch

I should have specified in .NET using only the code behind with no
control on the aspx(HTML) side.

I am rendering a graphic from the OWC11...

Now the same question as before...

I need to move the X-Axis Values (Labels) from the default bottom of
the chart to the top of the chart for a chChartTypeBarClustered
charttype.

In excel you can do this by right clicking on the y-axis then clicking
Format Axis>Scale> and checking Categories in reverse order.


I'm sure this is very intuitive but I'm only about a day into the OWC
stuff..
 
P

p.

This will move the x-axis values from the default bottom to the top of the
chart.

AxChartSpace1.Charts(0).Axes(Microsoft.Office.Interop.Owc11.ChartAxisTypeEnum.chValueAxis).Position
= Microsoft.Office.Interop.Owc11.ChartAxisPositionEnum.chAxisPositionTop

Check the Namespace Microsoft.Office.Interop.OWC11 for ChartAxisTypeEnum and
ChartAxisPositionEnum.

Regards,
p.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top