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