Why does X axis become another data series?
in [Charts]
|
Prev: How can I reset the default pie chart label "Other" to "Equity"?
Next: below is from visifire help doc
From: Philip Reece-Heal on 4 Dec 2009 06:13 Take the following data to use with Chart Wizard to get a chart: Distance height 0 5 5 4 8 3 9 6 12 7 13 8 If I highlight all data including column titles, the chart wizard produces both columns as Series, whereas I want Distance column to be X axis values. Why is this? If I delete the column heading 'Distance' and leave that cell blank it works OK, as it does if 1st column contains dates. It is annoying when I want to quickly highlight data in a spreadsheet to produce a chart . Anybody got any simple solution? Regards Phiulip
From: "David Biddulph" groups [at] on 4 Dec 2009 06:58 Simple solution, as you've found, is to leave the X axis column heading blank until after you've produced your chart, and then fill it in. -- David Biddulph "Philip Reece-Heal" <philipreeceheal(a)gofast.co.uk> wrote in message news:B832315C-268D-4B03-A311-C348920C16EB(a)microsoft.com... > Take the following data to use with Chart Wizard to get a chart: > > Distance height > 0 5 > 5 4 > 8 3 > 9 6 > 12 7 > 13 8 > > > If I highlight all data including column titles, the chart wizard produces > both columns as Series, whereas I want Distance column to be X axis > values. Why is this? > > If I delete the column heading 'Distance' and leave that cell blank it > works OK, as it does if 1st column contains dates. > > It is annoying when I want to quickly highlight data in a spreadsheet to > produce a chart . > > Anybody got any simple solution? > > Regards > > Phiulip
From: Jon Peltier on 4 Dec 2009 11:49
If you make an XY chart, which suits this data better than other chart types, Excel will automatically use the first column for the X values. If you make another chart type, the first column must be obviously different: date format, text format, missing the label in the first row. Easier than omitting the X values from the selected range and filling it in later is to make an XY chart, then change it to the chart type you want. As I said, though, your sample data will be best displayed in an XY chart, because both X and Y have non-consecutive numerical values. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Philip Reece-Heal wrote: > Take the following data to use with Chart Wizard to get a chart: > > Distance height > 0 5 > 5 4 > 8 3 > 9 6 > 12 7 > 13 8 > > > If I highlight all data including column titles, the chart wizard > produces both columns as Series, whereas I want Distance column to be X > axis values. Why is this? > > If I delete the column heading 'Distance' and leave that cell blank it > works OK, as it does if 1st column contains dates. > > It is annoying when I want to quickly highlight data in a spreadsheet to > produce a chart . > > Anybody got any simple solution? > > Regards > > Phiulip |