Forum Discussion
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 correctly
- Right side: same graph in Word, where the labels are showing index values
NB! Please take note; my data for the source graph in Excel is dynamically being selected with the use of Name Manager, selecting only non-zero rows. It seems to be this particular step that creates the problem with 1,2,3, etc. being shown as lables instead of the text descriptions.
Does anyone know how I could fix this?
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.
6 Replies
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.
Leila Gharani If I understand you correctly, that would simply leave me back at the start: with a range without the possibility to dynamically skip/ignore blanks. The whole clue of your guide was to use Name Manager as data selection to sort out blanks in the final graph.
Am I missing something?
This way the graph in Word will be exactly what you see in Excel. If Excel changes, the Word graph will change too.
