Forum Discussion
Graph in Word not showing labels correctly (when using Name Manager in Excel to select data)
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.
Leila Gharani Yes, but if I do that, I loose the dynamic skipping of blank cells (since the graph in Word is now set to show the whole range, and not just the "non-blanks" using Name Manager).
Tormod Solem Slupphaug Sorry - I missed your response here.
An option is to use a technique like this: https://youtu.be/T8P8xMBkH4I
Then once the chart is already fixed on the Excel side, then link the result to Word.
Not sure if that would work with your data organization.
You can't do filtering or editing the chart in Word - it has to be done in the source.
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.