Home

How to display (in Office 365 excel for mac) a 'hidden' column in an Windows excel chart

%3CLINGO-SUB%20id%3D%22lingo-sub-658696%22%20slang%3D%22en-US%22%3EHow%20to%20display%20(in%20Office%20365%20excel%20for%20mac)%20a%20'hidden'%20column%20in%20an%20Windows%20excel%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-658696%22%20slang%3D%22en-US%22%3E%3CP%3EA%20colleague%20has%20created%20an%20excel%20chart%20which%20has%20columns%20for%20a%20range%20of%20years%20from%202012%20to%202022.%26nbsp%3B%20All%20these%20years%20are%20selected%20in%20the%20'Select%20Data%20Source'%20tool.%26nbsp%3B%26nbsp%3B%20In%20other%20words%2C%20the%20'Range%20Details'%20field%20contains%20all%20columns%20and%20all%20rows%20with%20data%20in%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20when%20I%20view%20the%20chart%20on%20my%20mac%20(excel%20for%20Office%20365)%20I%20can%20only%20see%20values%20for%20the%20years%202012%20to%202017.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20use%20my%20mac%20to%20amend%20the%20chart%20to%20include%20say%20values%20for%20the%20year%202018%3F%26nbsp%3B%20(Or%20do%20I%20need%20to%20go%20to%20a%20Windows%20machine%20to%20do%20this).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-658696%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
conchubhar
Occasional Visitor

A colleague has created an excel chart which has columns for a range of years from 2012 to 2022.  All these years are selected in the 'Select Data Source' tool.   In other words, the 'Range Details' field contains all columns and all rows with data in them.

 

However, when I view the chart on my mac (excel for Office 365) I can only see values for the years 2012 to 2017.

 

How can I use my mac to amend the chart to include say values for the year 2018?  (Or do I need to go to a Windows machine to do this).

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies