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: 1
Default Charting based on a specific month in a column

Hi all,

I would like to plot a bar chart that plots the bar based on the sum of
a column for a particular month. For example:

A1 Date
A2 1/5/09
A3 2/5/09
A4 1/6/09

B1 Qty
B2 10
B3 10
B4 5

I would like to plot a bar chart that on the bottom axis has the months
i.e. May, June and then sums up column B and plots the sum of the
figures against the months i.e. May - Qty 20, June - Qty 5 etc.

I appreciate any assistance you can give me.
 
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
Sum specific column rows based on 2 different column criteria Jack Excel Worksheet Functions 3 October 9th 08 05:03 PM
Count a specific month in a column Elaine Excel Worksheet Functions 7 July 1st 08 09:30 AM
Calc Prorated Cost based on Specific Days in a Given Month & Year Range (Revisited..) [email protected] Excel Discussion (Misc queries) 8 October 2nd 07 12:15 AM
Getting column value based on month [email protected] Excel Worksheet Functions 2 June 3rd 06 09:50 AM
SUM/COUNT column(s) based on specific value present within the column markx Excel Worksheet Functions 6 March 22nd 05 10:23 AM


All times are GMT +1. The time now is 03:07 PM.

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"