Combined charts - x-y scatter (or line) and columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kurt Bonner - 07 Nov 2003 14:26 GMT

"How do I change the format of a data series in a chart from a line to a column?"

Reply to this Message

dvt - 07 Nov 2003 15:36 GMT

> "How do I change the format of a data series in a chart from a line to a
> column?"

Select the data series by clicking on it. On the menu, click Chart |
Chart type | select a column chart. If you do this as instructed (i.e.
with the data series selected), only the selected data series will
change. The other data series will remain as before.

Signature

Dave
dvt at psu dot edu

Reply to this Message

Jon Peltier - 08 Nov 2003 04:33 GMT

>> "How do I change the format of a data series in a chart from a line to
>> a column?"

> Select the data series by clicking on it. On the menu, click Chart |
> Chart type | select a column chart. If you do this as instructed (i.e.
> with the data series selected), only the selected data series will
> change. The other data series will remain as before.

Even quicker: right click on the series, choose Chart Type from the pop
up menu, and select the intended chart type.

And if you want to repeat this with another series, select the second
series right after changing the first, and press the F4 key.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Reply to this Message