View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Mas[_2_] Mas[_2_] is offline
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.