Excel VBA Chart Legend "bug"
Budget: ₹600 – ₹1,500 INR
I have a worksheet with multiple data columns and I want to add 9 selected columns to a chart. The chart is created with the date (column A) and series 1-4 (columns B-E).
A VBA function is used to add the series 5-9 (columns Q, P, J, K, L). The Series are inserted ok and are listed correctly in the series collection name array.
The problem is the chart legend does not have the same series order. It all goes wrong after column 5 and legend entries 7-9 are inserted BEFORE entry 6 and not appended AFTER it.
I have a sample spreadsheet that demonstrates the problem. I use an Excel addin that has 2 functions that are used to insert the chart lines. It is simple code but I do not know Excel well enough to fix this problem. It has taken me 2 days to isolate it.
The attached PDF file shows exactly what is going wrong
The successful bidder will get the sources to the two addin functions.
I need the series to be appended to the legend in the order they are added AND to understand exactly why this is happening.
A VBA function is used to add the series 5-9 (columns Q, P, J, K, L). The Series are inserted ok and are listed correctly in the series collection name array.
The problem is the chart legend does not have the same series order. It all goes wrong after column 5 and legend entries 7-9 are inserted BEFORE entry 6 and not appended AFTER it.
I have a sample spreadsheet that demonstrates the problem. I use an Excel addin that has 2 functions that are used to insert the chart lines. It is simple code but I do not know Excel well enough to fix this problem. It has taken me 2 days to isolate it.
The attached PDF file shows exactly what is going wrong
The successful bidder will get the sources to the two addin functions.
I need the series to be appended to the legend in the order they are added AND to understand exactly why this is happening.