I have a chart that I need to make the first row optional. This is the old style chart, not an Excel-based chart. An example image I found for discussion purposes here.
Manually, I can turn off a row by double clicking on the leftmost 'cell' - e.g. double clicking on the button/cell to the left of the 'West' label cell in the rreferenced image would turn off row 2 in that chart, and the middle light green bars would be removed from the chart.
I need to be able to turn on or off a row in my code. I can access other items, such as the cell values or Chart Title like this:
[vba] oShape.OLEFormat.Object.ChartTitle.Text
[/vba]
but I don't know how to reference that part of the chart. Is there a property or method to include/exclude a row from the chart?.
I hope someone can help me on this, it has been thrown at me with little time to solve the issue. Thanks in advance
Edit: I'd also like to know if there is somewhere where I can view the complete object hierarchy of these chart objects. I have never found one.
Reply With Quote