Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Charting
For complex dashboard: What type of chart to use?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Jon Peltier, post: 2628339"] Task and milestone names: Use data labels. Doing this manually is a chore, but there are a couple free Excel add-ins you can download to make this much easier: Rob Bovey's Chart Labeler, [URL]http://appspro.com[/URL] John Walkenbach's Chart Tools, [URL]http://j-walk.com[/URL] You can make the formulas as complicated as you want. To get different colored bars, create multiple series, so that at each category you have a dummy invisible bar (on which other bars float), then one or more other bars, depending on which color(s) you want. If a color is not to appear at a given category, the associated value should be zero. - Jon [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Charting
For complex dashboard: What type of chart to use?
Top