Charting

jomansfi87106

HI,

The columns in this chart are not centered in their place between the grid lines, which seems to group the FC (forecast) from one month with the actuals from the next month. Can this be changed?

John

KPH

It looks odd at the moment as each grid section has space for both series but only data for one so you have left blank blank right left blank blank right....

Could you make your x-axis just the month and have "FC" and "Actuals" as the series labels? Then "Jan Actuals" and "Jan FC" would both be in the same grid section (the section would be "Jan").

jomansfi87106

I'll play with this suggestion - thanks for the tip!

KPH

No problem. Hope you can get it to look how you want.