8 Replies Latest reply on Jan 21, 2019 4:57 AM by Yuriy Fal

    How do I create a bullet chart with multiple measures (i.e. Sales, Net Sales, Profit, Market Share, etc.) and show the actual values to the right on a dashboard.  I ready an article by Stephen Few on bullet graphs and the example in the article is exactly

    Michael Hamilton

      How do I create a bullet chart with multiple measures (i.e. Sales, Net Sales, Profit, Market Share, etc.) and show the actual values to the right on a dashboard.  On the left I would like to show the trend over time.  I ready an article by Stephen Few on bullet graphs and the example in the article is exactly what I would like to create.  I have attached a picture of the Dashboard.  Does this require having 3 separate workbooks?  If so, how do you get them to align on one dashboard?  Thanks

      http://www.perceptualedge.com/articles/misc/WhyMostDashboardsFail.pdf

       

      Dashboard_SparklineBulletGraphAndActualValue.jpg