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

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

On Fri, 7 Nov 2003 06:26:10 -0800, Kurt Bonner =

wrote:

"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.

-- =

Dave
dvt at psu dot edu

On Fri, 7 Nov 2003 06:26:10 -0800, Kurt Bonner
wrote:

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


dvt wrote:
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
_______