Hello:

Plot the YTD on the secondary (right) axis).

Pieter Vandenberg

chiuinggum wrote:
: 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'.