Excel Custom Graphs
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. |
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/ _______ kgscrapman wrote: 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. |
All times are GMT +1. The time now is 10:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com