line-column charts

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I charted 5 lines of data (8 data points in each line) in
a combination chart (line-column) with one axis. It
defaulted to 3 lines of data displayed as columns and 2 as
lines. Is there a way to easily identify which data
sources I want in column format and which appear as
lines? I tried to select one of the lines and change the
chart type to "column", but the column displayed on top of
the other three. I was able to use this same approach to
solve my problem by creating a column chart and change the
one data set to a line chart, but I was hoping for a way
to format data back and forth more easily. Thanks.
 
Michael -

That's as easy as it gets. It's only a couple of clicks, though. RIght
click on the series, choose chart type, then pick out the chart type you
want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top