Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar and Line chart
I am using Excell 2003
I need to create a BAR graph with 3 years of Sales $$ (1 being the current year) and add to that a LINE that shows the BUDGETED $$ for the current year. From the Chart Wizard I chose the "line - column" chart because both the bars and the line are all using the same $$ numbers. Sales $$ for 2006 and 2007 came up as Bars but Sales for 2008 came up as a line along with the budget $$ being a line also. I now have a graph of 2 bars and 2 lines. I wanted 3 bars and 1 line. How do I get all 3 years of Sales to be bars and only the Budgeted Sales to be the line? I would certainly appreciate any help someone can give me. I am very frustrated. Aurora |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
Custom Line Width in Line or Scatter Chart | Charts and Charting in Excel | |||
Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) |