increase or decrease the x-axis label

[Guest]

I have a chart where the x-axis has a data series that I want to increase or decrease depending on the data table. If there is data show the label if not do not show and do not leave a space for it either. How can I do this?
Thanks for our help.

 

[Tushar Mehta]

I'm not sure if I truly understand your question. See if the following
answers it (or part of it):

Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions