Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Saving Custom Toolbars in Excel 2003 | Setting up and Configuration of Excel | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel | |||
Excel 2002 custom toolbars | Excel Discussion (Misc queries) | |||
Getting Excel 2003 to save Custom Toolbars | Excel Discussion (Misc queries) |