Mauritz
Board Regular
- Joined
- Dec 15, 2006
- Messages
- 53
I am using Office 2010 and Windows XP
For some reason the order of the items in the two column, multi row table I use for the bar chart gets reversed in the bar chart itself - item 1 in the table is the last item in the bar chart. I thought I was clever to merely reverse the order in my table and then the bar chart will reflect correctly, and this was fine until I started using VBA to change the colour of individual bars ie SeriesCollection(1).Points(x) where "x" is manipulated in the VBA code. The VBA uses the order of the table from top to bottom, whereas the actual bar chart reads from bottom to top, creating a mismatch so to speak if I use loops, etc to pass info from the table to the graph.
Is there a quick and easy way to overcome this?
Thanks
For some reason the order of the items in the two column, multi row table I use for the bar chart gets reversed in the bar chart itself - item 1 in the table is the last item in the bar chart. I thought I was clever to merely reverse the order in my table and then the bar chart will reflect correctly, and this was fine until I started using VBA to change the colour of individual bars ie SeriesCollection(1).Points(x) where "x" is manipulated in the VBA code. The VBA uses the order of the table from top to bottom, whereas the actual bar chart reads from bottom to top, creating a mismatch so to speak if I use loops, etc to pass info from the table to the graph.
Is there a quick and easy way to overcome this?
Thanks
