line chart problem: data points intersecting with border

G

gerridge

The first & last data points of my series are intersecting with the
vertical border of the chart area. I'd like to have a bit of a gap (so
I don't always have to reposition the data label for the final value
so that it falls inside the border... plus I think it would look
nicer), but none of the "offset" or any other controls in the chart
options seems to have any effect.

Any ideas? Thanks, DG
 
A

Andy Pope

Hi gerridge,

Check the X axis Scale setting
"Value (Y) axis crosses between categories" is checked.
Right click X axis and pick format Axis to display Format dialog.
The first & last data points of my series are intersecting with the
vertical border of the chart area. I'd like to have a bit of a gap (so
I don't always have to reposition the data label for the final value
so that it falls inside the border... plus I think it would look
nicer), but none of the "offset" or any other controls in the chart
options seems to have any effect.

Any ideas? Thanks, DG
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 

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

Unintended line connecting two data points 0
Data points in chart incorrect 0
Points on Line Chart 1
Line chart with dotted lines rendered poorly in presentation mode 0
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Labeling points on a line chart 1
Format Data Labels Doesn't Save 2
adjustable range radar chart 0

Top