line-column charts

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

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
simple chart 0
Labeling on independently stacked line chart 0
Move Chart with Text 0
Style Gallery View 3
column charts with set set of data 0
Multiple columns over a chart 0
One extra x axis item that wont go away - can anyone help? 3

Top