I'm plotting monthly and ytd data as columns on the x axis. And for the y
axis, I'm showing a percentage that relates to the monthly data, not the ytd
data. I've formatted the 4 sets of columns to "0 overlap" and "100 gap
width". So, for each set of columns (month and ytd), the month and ytd
columns are touching. Currently, the data point for percentage line on the y
axis sits in the middle of each set of columns. But since the percentage
data point really only relates to the monthly data, I was hoping to shift the
line so the data points are over the month column, instead of in between the
two columns. Is this possible? And if so, how can I go about shifting it
over the month column?

See http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"mktg@vzw" wrote in message
...
I'm plotting monthly and ytd data as columns on the x axis. And for the y
axis, I'm showing a percentage that relates to the monthly data, not the
ytd
data. I've formatted the 4 sets of columns to "0 overlap" and "100 gap
width". So, for each set of columns (month and ytd), the month and ytd
columns are touching. Currently, the data point for percentage line on
the y
axis sits in the middle of each set of columns. But since the percentage
data point really only relates to the monthly data, I was hoping to shift
the
line so the data points are over the month column, instead of in between
the
two columns. Is this possible? And if so, how can I go about shifting it
over the month column?