ok here is another example
so the graph is now in word
I want to switch the legend around here. The logical thing to do would be click on the textbox and type in what I want. Nothing happens if you do that. If you right click you get:
-format data series
NONE of these allow you to change the name.
The only option that works is to open excel, and edit the data series name itself. This really makes it a pain because on my spreadsheet i don't want to be constantly entering full text names. You should be able to simply change the legend text box on the published graph. Anyways once you have made the changes to the graph in excel, word does not automatically update the graph, nor is there a way (I am aware of) to simply update the graph. Instead I have to re copy and paste it into word, and again fix the small formatting issues that arise from it.
I know this isn't professional graphing software, but come on, this is not exactly intensive stuff here. I want to edit a textbox for gods sake.