Combo Bar-Line Graph with single list of data

M

Melody

Hi,

I'm trying to create a combination graph where my data for 2008 and 2009
shows as the year total represented by a bar. I want the 2010 data to show
by month. My data is listed by Month in Column A and the total by Month is
in Column B.

Date Total
Sep-08 7
Oct-08 9
Jan-09 15
Mar-09 25
Jun-09 50
Nov-09 75
Jan-10 100

Because the total is cumulative, I'm looking for the 2008 and 2009 data to
be the last total for that year (Oct-08=9, Nove-09=75)

Hope this makes sense. Any suggestions?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

weeks in a month 1
how to use if statements or vlookups 0
Find the position of a date 6
2 dimensional date sort 2
Formula required for # of days Calculation 3
Finding a sum by matching two cells with the same identifier 1
Sum Totaled based on Matching Identical Criteria in Worksheet 1
Match Dates in Two Cells and Ignore subsequent Cells 1

Top