Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Axis points
I am trying to create a chart for one months data using the dates along the
horisontal axis - as soon as i get to 20 dates i cannot increase the axis. Is there any way to do this? cant find anything in the set ups that says you are restricted to 20 points |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Axis points
Click on the chart area
You should see coloured lines ("range finders") around the data being used for the plot Drag these down to include all your data OR Just remake the chart best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "slugweeny1" wrote in message ... I am trying to create a chart for one months data using the dates along the horisontal axis - as soon as i get to 20 dates i cannot increase the axis. Is there any way to do this? cant find anything in the set ups that says you are restricted to 20 points |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Axis points
Put your data into a contiguous columnar range, then select the range, not
the individual cells. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "slugweeny1" wrote in message ... I am trying to create a chart for one months data using the dates along the horisontal axis - as soon as i get to 20 dates i cannot increase the axis. Is there any way to do this? cant find anything in the set ups that says you are restricted to 20 points |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different Starting Points on X-Axis | Charts and Charting in Excel | |||
Data points going from axis to axis | Charts and Charting in Excel | |||
How do I add the similar points together on the X axis | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
Secondary Axis Without Data Points? | Charts and Charting in Excel |