joshuafournier
Board Regular
- Joined
- Mar 3, 2012
- Messages
- 91
Greetings,
I currently have a chart. It collects the data from the same sheet. I only want to display the people involved.
I have upto 10 people. My chart always shows ten
I have a cell to decide how many people but i cant get the chart to follow. Ideally there is a VBA to check or uncheck the category axis labels (people)
I am currently changing the data source for the horizontal axis but it does not work properly. Still shows all 10.
Sheets ("sheet1").select
If (range ("bf1")=1) then
Activesheet.chartobjects ("chart 7").activate
Activechart.seriescollection (1).xvalues="='sheet1'!$bf$12:$bf $12"
Then i just rinse and repeat 10 times to cover the spread of the 10 operators.
I currently have a chart. It collects the data from the same sheet. I only want to display the people involved.
I have upto 10 people. My chart always shows ten
I have a cell to decide how many people but i cant get the chart to follow. Ideally there is a VBA to check or uncheck the category axis labels (people)
I am currently changing the data source for the horizontal axis but it does not work properly. Still shows all 10.
Sheets ("sheet1").select
If (range ("bf1")=1) then
Activesheet.chartobjects ("chart 7").activate
Activechart.seriescollection (1).xvalues="='sheet1'!$bf$12:$bf $12"
Then i just rinse and repeat 10 times to cover the spread of the 10 operators.
