Andreas Hermle
asked on
Creating a simple barChart using current region
Dear Experts:
I would like to create a bar chart using VBA with the following requirements
The range is to be the current region (starting from range("C2"))
The Chart is to be a bar chart (xlBarClustered) to be placed on the currently active sheet
No major gridlines on the value axis, no MajorTickMarks on the Category Axis.
No legend
Help is very much appreciated.
Thank you very much in advance.
Regards, Andreas
I would like to create a bar chart using VBA with the following requirements
The range is to be the current region (starting from range("C2"))
The Chart is to be a bar chart (xlBarClustered) to be placed on the currently active sheet
No major gridlines on the value axis, no MajorTickMarks on the Category Axis.
No legend
Help is very much appreciated.
Thank you very much in advance.
Regards, Andreas
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
this did the trick, thank you very much for your great help. I really appreciate it.
Regards, Andreas