View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Onno Onno is offline
external usenet poster
 
Posts: 1
Default How to plot chart where X axis values START 1

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.