| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 108767 | 2010-04-11 01:35:00 | MS Excell graph problem. | Colpol (444) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 875029 | 2010-04-11 01:35:00 | Is it possible to define the range of a graph. I have a graph setup as follows. The graph displays the number of widjets sold by month and year. For the last 5 years the monthly numbers have been between 500 and 1100(nothing below 500). When I display them in a graph the lower half contains no data but the graph insists that the bottom line is 0. I need to tell it that the bottom line is 500. The top half of the graph is now very crowded. Without the bottom section the graph will disply more clearly. Hope this makes sense. Cheers Colin |
Colpol (444) | ||
| 875030 | 2010-04-11 01:48:00 | You should be able to change it. Depending what version of excel you are running. | nedkelly (9059) | ||
| 875031 | 2010-04-11 01:51:00 | Ok you can, click on one of the values going up the side, then right click on the box that appears and select format axis, then set minimum to 500 | nedkelly (9059) | ||
| 875032 | 2010-04-11 01:53:00 | Running Excell 2007. My Question is how to change it? |
Colpol (444) | ||
| 875033 | 2010-04-11 01:57:00 | click on one of the values going up the side, then right click on the box that appears and select format axis, then set minimum to 500. | nedkelly (9059) | ||
| 875034 | 2010-04-11 02:09:00 | Thanks NK. That did the trick:banana:clap:thumbs: New the answer would be simple. As usual "help" was no help at all. Cheers Colin |
Colpol (444) | ||
| 1 | |||||