I have a straightforward graph of grade point averages for a college student, the Semester GPA and then the Cumulative GPA
I need to draw a bold line on the 2.0 line. I don't think you can do this with chart properties. So I just placed a cell on top of the chart at the 2.0 value line, with a nice crisp bold border.
The cell is aligned to the top of the chart. But in some cases it's good, in other cases it's not, and I can't figure out why ...
- the chart size is fixed
- the line is aligned to 1.43" below the top of the chart.
Doesn't work ... :-( but why? The graph size isn't changing with the data.
So what could be the reason the line isn't in the same position every time?
I had a suggestion to try a second chart, but it's still overlaying. I'd like to find out why my solution doesn't work.
Another suggestion was to create a constant as another data series, but that's not ideal - there are data markers, etc., so not usable imo.