View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
chiuinggum
 
Posts: n/a
Default trend chart with cummulative column

i would like to plot a chart that has combination of column trend chart, goal
line chart and a cummulative column chart.

Jan=1000/Feb=1500/Mar=1200/Apr=1500/May=1200/Jun=1000/Jul=1500/Aug=1400/Sep=1450/Oct=1250/Nov=1100/Dec=1200

Goal = 1500 for Jan to Dec
YTD= Year to date

If I use the same axis for the column trend chart and YTD column chart, the
chart will be lobsided with YTD column so 'tall'.