• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 47
  • Last Modified:

MS Excel Clustered Column graph - Suggestions on how to display 0

Is there any way for a clustered column graph to be better represented for a  0 value for a category.  

Since it is 0 obviously there is no bar, but graphically is there a suggestion on how I can convey the value 0.  The clustered column graph looks odd for a clustered column chart type when one column is 0 and the other column is > 0.
0
upobDaPlaya
Asked:
upobDaPlaya
  • 4
  • 3
1 Solution
 
Martin LissOlder than dirtCommented:
Take a look at the 2022 Dolphin popolation in this "angled" clustered column graph .
2018-04-14_20-45-46.png
1
 
Martin LissOlder than dirtCommented:
Here's the workbook.
29094538.xlsx
1
 
abbas abdullaCommented:
Hi,

IF you want no column to appear for zero values then keep the zero value as blank the small visual will disappear.
1
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
upobDaPlayaAuthor Commented:
Spot On.  Thx !
0
 
Martin LissOlder than dirtCommented:
Spot On.
Who? And in any case please don't forget to close the question.
0
 
upobDaPlayaAuthor Commented:
Since they went to the new format it seems to be a nightmare to close out a question..I could have sworn I assigned point to Martin anc losed question..Let me try again.
0
 
upobDaPlayaAuthor Commented:
Spot on..Exactly how I need the view to display !
0
 
Martin LissOlder than dirtCommented:
You’re welcome and I’m glad I was able to help.

If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange Most Valuable Expert (MVE) 2015, 2017
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
              Experts Exchange Top Expert VBA (current)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now