General discussion

  • Creator
    Topic
  • #2313571

    Graphs in Excel

    Locked

    by keepbelieving ·

    Hi 🙂
    Please help me! I would like to add a target point to a graph, but can’t figure out how to do it. I am using a bar graph that has a targeted budget at 10.5. I would like to place a red line across the chart at that point to show how underor over budget I am. How do I add the line?

All Comments

  • Author
    Replies
    • #3397015

      Graphs in Excel

      by dklippert ·

      In reply to Graphs in Excel

      Column charts are easy. Add an extra data series called Budget with all values of 10.5. Use the custom graph type of Line column.
      With a Bar chart, you might cheat and use a line drawn using the Drawing tool bar.

      • #3456701

        Graphs in Excel

        by keepbelieving ·

        In reply to Graphs in Excel

        Thanks this helped a lot…why didn’t I think of that?

    • #3456700

      Graphs in Excel

      by keepbelieving ·

      In reply to Graphs in Excel

      This question was closed by the author

Viewing 1 reply thread