Excel Custom Graphs

K

kgscrapman

Can you create a Graph using bars for some data and switch to using lines for
the rest using 2 axes.
i.e. Charting production numbers The bars and one axis for previous years
totals. The line would be for each week for present year using the other axis.
 
J

Jon Peltier

Make the chart with all lines or all columns (whichever type is
predominant). Select a series you need to change, go to Chart Type on
the Chart menu, and change this series to the other type. Repeat with
each additional series you need to change (you can select the next
series and press the F4 key to repeat the last operations).

- 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

Getting the graph style I want 4
Plotting Line Graphs to Specific Bar Graphs 0
Plotting against Date (collating months) 2
Overlay line graph points on bar graph 1
Combining a 2-D column graph and a 2-D line graph on the same char 3
Where Did My Graph Go, Please ? 0
Odd chart type needed 1
Creating a clustered column chart 1

Top