Hi
I am trying to create an image of a chart, as well as the actual chart in Excel. However when I create a small image the tick labels on the category axis merge together then there are a lot of tick labels. In Excel the tick label spacing is automatically adjusted to display most appropriately. I have found the property to set the number of tick marks between point labels, however is there a way of getting the value automatically set according to the size of chart when creating an image?
Many thanks