Discussion on:

2
Comments

Join the conversation!

Follow via:
RSS
Email Alert
0 Votes
+ -
No negative plot
nick.harrison@... Updated - 17th Jan
Hello Susan,
For a complete Excel nob like me that was a very helpful article.
I may have made a mistake somewhere but I found that the negative value for Hancock in 2010 does not perform a reverse chart plot and looks a little misleading. Is this an Excel issue or me?
Nick
0 Votes
+ -
Contributr
Nope, it isn't you. I wish I'd noticed this before -- but it's the discrepancy between the values. All the other values in in the 100k -- this one's a measly $10,000 -- try changing any of the values to $10,000 and they won't show up either -- the negative isn't the problem. It's the axis units. Sometimes you can enlarge the actual chart object, but in this case, that's not going to be of much help. I think changing the units is the only viable option to catch that. Thanks for bringing it up!
Keyboard Shortcuts:
Prev
Next
Toggle
Join the conversation
Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.