#1   Report Post  
Posted to microsoft.public.excel.misc
Jason - MR
 
Posts: n/a
Default double bar graph

I need help creating a bar graph. I have actual and budget data that I want
to post along side each other for each month. I've been unable to locate
this option.

Please help, Thanks!! Jason
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default double bar graph

H Jason,
Excel's bar charts have the bars running horizontally. When you say you
want the actual and budget data "along side each other", you are
implying that you want the bars running vertically, which would be a
column chart.
I'm going to assume you actually want a column chart.
I'm also going to assume that your data consists of 3 columns; Date,
Actual and Budget in that order across the sheet.
1. Select your three columns, including the headings.
2. Click on the Chart wizard icon or go InsertChart
3. The Column chart is already highlighted in the dialog and the side
by side arrangement of columns is also already highlighted so just
click Next unless you prefer one of the 3-D versions shown below.
4. Make sure Columns is selected on the Data Range tab where it says
Series in:, then click Next.
5.This step has a lot of options such as Title, Axes labels, grid lines
etc so just experiment or just click Next because these options can be
adjusted later.
6.This step is where you can have the chart on the worksheet or as a
separate Chart sheet.
7. If you are not happy with spacing of the columns just double click a
column, select the Options tab and adjust the Gap and /or Overlap.

Ken Johnson

Reply
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
Add excel horizontal & vertical ruler snbahri Excel Worksheet Functions 8 December 1st 06 07:18 PM
Bar graph and line graph overlayed MikeR-Oz Charts and Charting in Excel 4 February 6th 06 07:01 AM
Hyperlinkage of one graph with another graph or Drill down graph Sanjay Kumar Singh Charts and Charting in Excel 1 January 3rd 06 12:22 PM
Double clicking in a Pivot Table, Please HELP marko Excel Discussion (Misc queries) 3 December 27th 05 07:52 AM
Graph Axes Robin Excel Discussion (Misc queries) 0 December 8th 04 08:03 PM


All times are GMT +1. The time now is 12:06 AM.

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

About Us

"It's about Microsoft Excel"