EXCEL Custom Type charts

L

LACHO

Can someone help me with my Line-Column chart, It has 5 fields 4 should be
bars and 1 should be a line, but excel automatically puts 3 bars and 2
lines, how can I change one of the lines to a bar in the custom line-bar
chart
 
J

Jon Peltier

Select the series you want to change, go to Chart menu > Chart Type, and
select the type you want.

Next time, skip the "built-in custom" types, and start with a column chart,
then change the one series to a line as described above.

- Jon
 

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

Paragraph numbering in Word 1
Autonumber field in Excel that behaves the same as Access 0
sideways stacked bar charts with line series on the same axis 0
Style Gallery View 3
Adding a line to a bar chart 1
One extra x axis item that wont go away - can anyone help? 3
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
List all tables, including document structure 0

Top