How do I specify using lines or bars on graphs w/ 2nd value axis?

M

Motorhead

I am building a chart using a secondary axis with both the data displayed in
both bars and lines. Everytime I add a new field Excel decides if it will be
displayed as a bar or a line. How do I control that decision myself. I
understand how to align data to a secondary axis, but not how to control the
bar vs line option.
 
J

Jon Peltier

Create your chart using all lines or all bars. Select one to change, and
use Chart Type on the Chart menu to change it. Select the next to change
and use the F4 function key shortcut for Repeat Last Action. Etc.

- 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

Graphs: 2 Lines on secondary Y-axis? 1
sideways stacked bar charts with line series on the same axis 0
multiple series bar and line chart 2
Overlay line graph points on bar graph 1
Chart data scrunches to left when adding X axis date series 0
vertical scale on both ends of bar chart 1
Charting on Primary & Secondary Axis - Zero Point Does Not Align 1
how to combine two chart type in one graph 5

Top