Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic axis format
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............. |
#2
|
|||
|
|||
Hi,
Have a look at Jon's examples of dynamic charts. http://peltiertech.com/Excel/Charts/Dynamics.html Cheers Andy jos wrote: 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............. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why can I not format a secondary axis in excel x? | Charts and Charting in Excel | |||
Formatting dates on x axis of chart...! | Excel Discussion (Misc queries) | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |