Nov 25 2020
06:03 AM
- last edited on
Feb 01 2023
12:40 PM
by
TechCommunityAP
Nov 25 2020
06:03 AM
- last edited on
Feb 01 2023
12:40 PM
by
TechCommunityAP
My Word-graph is not showing labels correctly. The graph is copied from Excel, and data is linked.
See screenshot below.
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?
Nov 25 2020 01:43 PM
@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.
Nov 25 2020 01:55 PM
@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?
Dec 01 2020 04:10 AM
This way the graph in Word will be exactly what you see in Excel. If Excel changes, the Word graph will change too.
Dec 01 2020 04:23 AM
@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).
Dec 08 2020 12:03 AM - edited Dec 08 2020 12:11 AM
Dec 08 2020 12:03 AM - edited Dec 08 2020 12:11 AM
@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.
Dec 08 2020 02:27 AM
SolutionYepp, 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. :smiling_face_with_smiling_eyes:
Thank you for following up on my questions Leila.
Dec 08 2020 02:27 AM
SolutionYepp, 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. :smiling_face_with_smiling_eyes:
Thank you for following up on my questions Leila.