Forum Discussion
Tormod Solem Slupphaug
Nov 25, 2020Iron Contributor
Graph in Word not showing labels correctly (when using Name Manager in Excel to select data)
My Word-graph is not showing labels correctly. The graph is copied from Excel, and data is linked. See screenshot below. Left side: my source data and graph (in Excel) with labels showing up...
- Dec 08, 2020
Yepp, this was the guide I followed (see link in my first post). Strangely, when using Name Manager to select data for the graph, the labels are being replaced by numbers when copying the graph from Excel to a Word document.
Unfortunately, I was unable to find a non-vba solution to this, but I've fixed it by running a macro that sorts out blanks, instead of using Name Manager, so problem solved. 😊
Thank you for following up on my questions Leila.
Nov 25, 2020
Tormod Solem Slupphaug Try this: Highlight the cells on which the graph is sitting on (so not the chart itself, but the cells it's on) - then copy and paste as link.