Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Number of categories
I need to make a macro to change the between tick-mark labels with a value
depending of the total numbers of rows, but I do not now the VB code to put the number of categories in the graph. I'm not a expert in VB coding, any help is appreciated, Thanks, jos |
#2
|
|||
|
|||
One of my favorite programming tools is the macro recorder. Go to Tools
menu Macros Record New Macro, carry out the steps you want to automate, stop the recorder, then examine the recorded code to see what you need to insert into your procedure. You'll probably have to clean it up a bit. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Jos wrote: I need to make a macro to change the between tick-mark labels with a value depending of the total numbers of rows, but I do not now the VB code to put the number of categories in the graph. I'm not a expert in VB coding, any help is appreciated, Thanks, jos |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
Roundup to the nearest number that is divisible by 3 | Excel Worksheet Functions | |||
doubling a number X number of times | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
How do I sort a column a unique number? | Excel Worksheet Functions |