Automatic axis format

J

jos

Hi,
I'm need to make a automatic axis format within excel.
The number of rows is depending of a imported file.
No problem to get the max. number of rows.
But to put this number into the chart ( category axis) is more problematic.
I try VB but my knowledge is at dummy level !
Waiting for your reply.............
 

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

Similar Threads

Formatting 'X' Axis -- 2 fundamental differences 7
Conditional number format of x-axis based on value? 2
Custom EXCEL chart value axis BRAIN TEASER 1
Overlaying 2 Data Series with Different Time (X) Axis 3
Clusted stacked column chart - "Value (Y) axis crosses betweencategories" greyed out problem 0
Charting with irregularly spaced x-axis 1
Axis formatting 0
Multi-level Category Axis Fails with >100 rows of data 0

Top