SOLVED

Graph in Word not showing labels correctly (when using Name Manager in Excel to select data)

%3CLINGO-SUB%20id%3D%22lingo-sub-1930871%22%20slang%3D%22en-US%22%3EGraph%20in%20Word%20not%20showing%20labels%20correctly%20(copied%20from%20Excel%20with%20use%20of%20INDEX)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1930871%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20Word-graph%20is%20not%20showing%20labels%20correctly.%20The%20graph%20is%20copied%20from%20Excel%2C%20and%20data%20is%20linked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20screenshot%20below.%20On%20the%20left%20side%20you've%20got%20the%20source%20(graph%20in%20Excel)%20with%20labels%20showing%20up%20correctly%2C%20while%20on%20the%20right%20side%20(same%20graph%20in%20Word)%20the%20labels%20are%20just%20returning%20the%20index%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENB!%20Please%20take%20note%20of%20the%20formula%20hidden%20behind%20the%20Excel%20cells%2C%20which%20explains%20the%20source%20of%20this%20issue.%20My%20original%20data%20has%20been%20processed%20twice%20prior%20to%20being%20visualized%20in%20the%20graph%3A%3C%2FP%3E%3COL%3E%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FxO_lCIAlnV0%3Ft%3D235%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EFirst%20to%20rank%20and%20list%20categories%20from%20highest%20to%20lowest%20values%3C%2FA%3E%3C%2FLI%3E%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DT8P8xMBkH4I%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EThen%20to%20only%20list%20non-zero%20values%3C%2FA%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3EBoth%20of%20these%20steps%20use%20the%20INDEX%20function%20to%20process%20data%2C%20and%20I%20assume%20this%20is%20what's%20causing%20the%20INDEX%20values%20to%20show%20up%20in%20my%20Word%20graph%2C%20instead%20of%20the%20text%20descriptions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20adjusting%20the%20graph%20settings%20in%20Word%2C%20but%20without%20success.%20Note%3A%20when%20I%20insert%20the%20graph%20in%20Word%2C%20and%20when%20changing%20paste%20format%2C%20all%20of%20the%20text%20descriptions%20shows%20for%20a%20brief%20moment%20before%20reverting%20back%20to%201%2C2%2C3%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20I%20could%20fix%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F235990iA71D14AFA24DA9A0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1930871%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1932467%22%20slang%3D%22en-US%22%3ERe%3A%20Graph%20in%20Word%20not%20showing%20labels%20correctly%20(when%20using%20Name%20Manager%20in%20Excel%20to%20select%20data)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1932467%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F115731%22%20target%3D%22_blank%22%3E%40Tormod%20Solem%20Slupphaug%3C%2FA%3E%26nbsp%3BTry%20this%3A%20Highlight%20the%20cells%20on%20which%20the%20graph%20is%20sitting%20on%20(so%20not%20the%20chart%20itself%2C%20but%20the%20cells%20it's%20on)%20-%20then%20copy%20and%20paste%20as%20link.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1932480%22%20slang%3D%22en-US%22%3ERe%3A%20Graph%20in%20Word%20not%20showing%20labels%20correctly%20(when%20using%20Name%20Manager%20in%20Excel%20to%20select%20data)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1932480%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F34444%22%20target%3D%22_blank%22%3E%40Leila%20Gharani%3C%2FA%3E%26nbsp%3BIf%20I%20understand%20you%20correctly%2C%20that%20would%20simply%20leave%20me%20back%20at%20the%20start%3A%20with%20a%20range%20without%20the%20possibility%20to%20dynamically%20skip%2Fignore%20blanks.%20The%20whole%20clue%20of%20your%20guide%20was%20to%20use%20Name%20Manager%20as%20data%20selection%20to%20sort%20out%20blanks%20in%20the%20final%20graph.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20I%20missing%20something%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

 

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?

 

 

image.png

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?

@Tormod Solem Slupphaug 

This way the graph in Word will be exactly what you see in Excel. If Excel changes, the Word graph will change too. 

 

 

@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.

Best Response confirmed by Tormod Solem Slupphaug (Contributor)
Solution

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. :smiling_face_with_smiling_eyes:

 

Thank you for following up on my questions Leila.