Re: Pages 2: make a chart from a table?

Martin S Taylor wrote:

Paul Russell wrote

I want to make a line graph from a set of data, but if the relevant cell is empty, I want it to ignore it. eg. if January's sales are 100 and March's are 200, but there's no data entered for February, I'd like a nice straight line joining the 100 to the 200, cutting the February axis at 150 but with no little blob on the line to imply that the 150 came from actual data.

Is there a spread*** which will do this?


Excel will do this if you make the chart type "XY (Scatter)".


I can't get it to put the line in. If there's no data for a month, it leaves a break in the line. What am I missing?

MST


Sorry, yes, you're right. I hadn't appreciated the bit about the line being broken. I don't see any way around this in Excel so you may have to use a proper graphing package.

Paul
.

Loading