Goal Line in chart but not on data tabel

B

BMSpell

I have a chart which plots single monthly values for the year in a bar graph
mode. I wanted to add a goal line, so I entered another series to represent
a goal, plotted the value for each month, and formatted it so it will
appear as a line across the chart wtih no points. I don't want the goal
values to show up in the data table. How do I exclude them? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Goal Line Going Forward 1
Adding a line to a bar chart 1
How do I add a horizonal target/goal line to a line chart? 2
Creating a goal or target line 1
a line on the bar chart 2
Line Chart 1
Bar Graph with goal line 1
how do I add a goal line for a bar chart? 1

Top