Pop-Up Thingie
Sidebar
>>> Magnum BBS <<<
Home
Forum
Files
Dark
Log in
Username
Password
Sidebar
Forum
Usenet
MICROSOFT.PUBLIC.EXCEL.CH
How do I ignore Graphs zero values.
From
Sarah Martin
@21:1/5 to
All
on Fri Aug 14 11:18:45 2020
Sorry for rehashing a really old topic, but I've got that conditional formatting set on the ranges of cells I'm graphing, but the graphs still show the empty categories:
Screenshot of data tables:
https://www.dropbox.com/s/ckt2tx7j6zg2i5n/data.JPG?dl=0
Screenshot of graphs:
https://www.dropbox.com/s/gctgh55yhpdnklu/graphs.JPG?dl=0
Is there any way to make those automatically not show if their value is 0?
-Sarah M
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
Who's Online
System Info
Sysop:
Keyop
Location:
Huddersfield, West Yorkshire, UK
Users:
714
Nodes:
16 (
2
/
14
)
Uptime:
140:09:23
Calls:
12,087
Files:
14,998
Messages:
6,517,420