Labels and columns on tick marks in column chart

[folsomfisher]

Hi,

In the column chart, by default the columns bars and column labels appear between the X-axis tick marks as shown here:

default.JPG (23.79 KiB) Viewed 431 times

However, we would like the column bars and column labels to appear directly inline with the X-axis tick marks as shown here from the Excel mock-up:

desired.JPG (33.28 KiB) Viewed 431 times

Is this possible?

Thanks,
Todd

[Annika.Zhou]

Hello,

Thank you for your inquiry.
Please use the following code to set the position of the category axis to "On tick mark".

Code: Select all

chart.PrimaryCategoryAxis.AxisBetweenCategories = false;

Sincerely,
Annika
E-iceblue support team

[Annika.Zhou]

Hello,

Hope you are doing well!

Has the issue been solved now? Could you please give us some feedback at your convenience?

Thanks in advance.

Sincerely,
Annika
E-iceblue support team

[folsomfisher]

Hi Annika,

Sorry for the delay in my reply. I got redirected to another task and was only able to get back to this item this morning. Your solution worked perfectly. Thanks so much for the quick response!

Todd

[Annika.Zhou]

Hello,

You're welcome.

If you have other questions about using Spire.XLS in the future, please feel free to contact us.

Have a nice day!

Sincerely,
Annika
E-iceblue support team