Skip to Content
0
Jan 10, 2018 at 01:29 AM

how to draw a bold like across a simple graph

87 Views Last edit Jan 10, 2018 at 01:31 AM 2 rev

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.

Works!

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.