How to plot chart where X axis values START >1

[Guest]

My Y values start at X axis values that are >1. For example

x y
1 0
5 0
20 15
21 8
.. .
40 14

So I want my chart to show X values from 18 to, say, 42. Please do not tell
me to right click on x axis, click on format and set minimum to 18 because on
X axis format YOU CANNOT SET A MINIMUM - THE FACILITY ONLY EXISTS FOR THE Y
AXIS. Many thanks if someone can help.

 

[Tushar Mehta]

My Y values start at X axis values that are >1. For example

x y
1 0
5 0
20 15
21 8
. .
40 14

So I want my chart to show X values from 18 to, say, 42. Please do not tell
me to right click on x axis, click on format and set minimum to 18 because on
X axis format YOU CANNOT SET A MINIMUM - THE FACILITY ONLY EXISTS FOR THE Y
AXIS. Many thanks if someone can help.

That depends on what kind of a chart you have. If you create a XY Scatter
chart (or change a line/column/area chart x-axis type to 'Time scale'), you
can specify the min. x value.

Alternatively, adapt the ideas at
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html
particularly the examples that let you specify starting point / number of
items to show, etc.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions