LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 17
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cutting a line in a line chart when data series stops DannyS Charts and Charting in Excel 2 August 28th 07 10:38 AM
change last serie to be line in the line-column Excel chart in Wor Eric Charts and Charting in Excel 3 June 30th 07 04:58 PM
Custom Line Width in Line or Scatter Chart Marvin Charts and Charting in Excel 2 February 10th 07 05:44 PM
Getting line on line chart to display after creation from Pivot Table dcsi_jim Charts and Charting in Excel 8 February 6th 07 08:54 PM
Make a line in a bar chart, and change color of any bars that exceed the line MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM


All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"