SOLVED
Home

Dissapearing Chart Data

%3CLINGO-SUB%20id%3D%22lingo-sub-532140%22%20slang%3D%22en-US%22%3EDissapearing%20Chart%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-532140%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20that%20shows%20predicted%20and%20actual%20incoming%20money.%20On%20this%20worksheet%20I%20have%20a%20graph%20that%20show%20the%20above%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20VBA%20button%20that%20hides%20the%20rows%20of%20the%20data%20from%20which%20the%20graph%20is%20derived.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20hide%20the%20data%20the%20graph%20changes.%20ie%20the%20hidden%20data%20is%20no%20longer%20available%20on%20the%20graph.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20not%20what%20I%20want.%20I%20just%20want%20to%20want%20to%20hide%20the%20data%20in%20the%20list%20until%20it%20is%20needed%20to%20be%20viewed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVonryan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-532140%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-532403%22%20slang%3D%22en-US%22%3ERe%3A%20Dissapearing%20Chart%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-532403%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F323150%22%20target%3D%22_blank%22%3E%40vonryan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelect%20the%20chart%3C%2FP%3E%3CP%3ESelect%20the%20Chart%20Design%20ribbon%20tab%3C%2FP%3E%3CP%3EIn%20the%20Data%20group%20click%20Select%20Data%3C%2FP%3E%3CP%3EOn%20the%20form%20click%20Hidden%20and%20Empty%20Cells%3C%2FP%3E%3CP%3ESelect%20Show%20data%20in%20hidden%20rows%20and%20columns%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-532910%22%20slang%3D%22en-US%22%3ERe%3A%20Dissapearing%20Chart%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-532910%22%20slang%3D%22en-US%22%3E%3CP%3EPerfect%20answer%20thank%20you%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
vonryan
Contributor

Hi All,

 

I have a spreadsheet that shows predicted and actual incoming money. On this worksheet I have a graph that show the above

 

I have a VBA button that hides the rows of the data from which the graph is derived.

 

If I hide the data the graph changes. ie the hidden data is no longer available on the graph.

 

This is not what I want. I just want to want to hide the data in the list until it is needed to be viewed.

 

Please help.

 

Vonryan

2 Replies
Solution

@vonryan 

Select the chart

Select the Chart Design ribbon tab

In the Data group click Select Data

On the form click Hidden and Empty Cells

Select Show data in hidden rows and columns

 

 

Perfect answer thank you

@Peter Bartholomew 

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies