Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Bar-Line Graph with single list of data
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Bar-Line Graph with single list of data
Check out Jon Peltier's article:
http://peltiertech.com/Excel/Charts/BarLineCombo.html -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Melody" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data in columns convert to single line | Excel Worksheet Functions | |||
How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
charting a single bar graph on one line showing continuous info | Charts and Charting in Excel | |||
plotting a single line graph | New Users to Excel |