Hi Everyone,
I'm Coding a Macro that formats data so that it is eventually in two rows, one with the short form for a month, a line break and some other data on the next line, and the other with a percentage like this:
"Jan
2554" 12%
Before the macro is run some data exists in the sheet already, the macro adds three new rows then graph all the data. Everything works except when I graph the data using either a macro or just regular excel graphing techniques, there are a bunch of extra line breaks inserted into the axis labels that come from data that was generated by the macro. You can see what I mean in the picture I attached.
Excel Question.png
Has anyone encountered this/ does anyone know how to fix it? Thanks,
-Sean