Skip to main content
Question

How can I add a target goal for each individual column in a chart?

  • July 17, 2018
  • 0 replies
  • 61 views
Hi,

I have a bar chart built which shows the amount of tests completed (Y-axis) in each month+year (X-axis).  Each individual month requires a different amount of tests to be completed.  I am looking to display the amount of tests that need to be completed for each individual month+year.  Essentially, this will be used to verify every test has been run for each month+year.  For example, if the amount of tests completed for June is 17 but there are 18 required, I would like for the graph to display this.

I know that you can set a goal line for a graph, however this is a goal line for all values and not just for one specific column which is what I am looking for.  Is there some other way for me to display the amount of tests that need to be completed for each individual month+year?  I've thought about adding a second column for each month+year to display the amount of tests needed to be completed through a calculated column however I've had some trouble with this as well.

Any ideas would be helpful.  Thank you!
    This topic has been closed for replies.

    • DanLadner1
    • Registered
    • July 17, 2018
    If you can get to the # of tests completed and # of tests remaining (the # required minus the # completed), in two different fields, you can show them both in a stacked bar chart. You could show the # completed in green, and the # remaining in red, or something along those lines. This way, it would be clear what the total is (the total height of the combined bars), and how close you are to reaching it.

    I suppose you could also indicate an overage with a third field/stacked bar/color.

    Hope this helps.
    Terms & ConditionsAccessibility statement