Datapoints

D

Dondi

I have automatically generated datapoints in a chart that show up where I put
them, but in Print Preview show up on the top or bottom of the chart . I
have already tried to align them via the formatting option.

The only time they stay in place is when I make the chart smaller.
 
J

Jon Peltier

Do the axis scales change in print preview? If so you might lock them in.
Double click on an axis, and on the Scale tab, uncheck the box in front of
the Min and Max entries.

You cannot align data points using any formatting, since their position is
determined by the X and Y values in the source data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
 

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

Move Chart with Text 0
Combined line-scatter graph with 2 Y-axis messed up 2
Text boxes and arrows on charts help 1
Format column widths from one table to a separate table on same page 1
very odd bubble chart problem 3
How can the font and size of (all) citation numbers be altered? 1
Determine if data label overlaps chart title? 7
Lines in chart when no data is present 14

Top