Home

How to set Hidden and Empty Cells through a Macro

%3CLINGO-SUB%20id%3D%22lingo-sub-558812%22%20slang%3D%22en-US%22%3EHow%20to%20set%20Hidden%20and%20Empty%20Cells%20through%20a%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-558812%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20building%20a%20macro%20that%20charts%20a%20line%20graph%20but%20the%20line%20stops%20if%20the%20data%20stops%20but%20the%20time%20goes%20on.%20%26nbsp%3BI%20can%20manually%20set%20the%20Hidden%20and%20Empty%20Cells%20to%20zero%2C%20but%20can%20not%20find%20how%20to%20do%20this%20through%20the%20macro.%20%26nbsp%3BHere%20is%20an%20image%20of%20what%20I%20am%20trying%20to%20accomplish.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20977px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112960iEF27AA198AC540A2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22ChartEx.png%22%20title%3D%22ChartEx.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-558812%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
Highlighted
jdomino
Occasional Visitor

I am building a macro that charts a line graph but the line stops if the data stops but the time goes on.  I can manually set the Hidden and Empty Cells to zero, but can not find how to do this through the macro.  Here is an image of what I am trying to accomplish.

ChartEx.png

 

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies