View Single Post
  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi,

Double click the x axis and on the scale tab uncheck the "Value (Y) axis
crosses between categories".

Cheers
Andy

Xaver Hinterhuber wrote:
Hello,

I want to draw a line chart that looks like the following

| +
| +
| +
| +
| +
|________
| | | |
1 2 3 4

How can I do that? It always looks like that:

| +
| +
| +
| +
| +
|________
| | | |
1 2 3 4

Greets

Xaver



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info