That works, but... can you tell me why the line chart isn't working? I have
one right in the same file and have no issue modifying the x-axis scale. I
even tried copying it and changing the data references.
Microsoft are all messed up when it comes to talking about charts. They
call a graph of interval against category a "line" chart. even though
the data may be in markers, lines, or lines *and* markers. And then they
talk about a graph of interval against interval a "scatter" chart, even
though it could just as easily be presented with lines.
Have you checked that the thing you call a "line" chart really is one? I
bet you'll find it's a "scatter" chart that happens to be formatted
using lines.
Way back in the dark ages, Lotus produced a basic and primitive graphing
facility in their spreadsheet. Microsoft knocked it off almost feature
for feature and called it "charting", and it hasn't really advanced
since then. The trouble is that they reproduced Lotus 123's bad design
features as well as the good ones, when a truly logical design would
have actually resulted in a quality improvement over their competitor.
But 'twas ever thus with MS. They never choose design quality when sheer
market dominance will suit their purpose just as well. I have this
fantasy that one day someone will design a graph utility based on known
principles of good visual display practice. One of those principles is
the "nominal, ordinal, interval" nomenclature devised by Stanley Stevens
in the 1940s, and I'd like to see a program where you could choose those
features of graph X and Y axes independently of the bogus "chart type"
nomenclature of line, scatter, etc.
http://en.wikipedia.org/wiki/Level_of_measurement
For now, just remember that "line" isn't about lines, it's about
category x-axis, and scatter isn't about markers, it's about interval
x-axis. Either type can have lines or markers or both.
