Help with Charts

[gecc1]

I have a document which has several charts which contain info for 2 fiscal years. Is there any way to mark or define the 2 fiscal years within the same chart. Example: expanding the tick mark of the 1st month of the fiscal year or; changing the font color of the tick mark, etc.

 

[dcnick]

If you have your charts set up so that each fiscal year is a series, then you can use different colors or tick mark symbols for each series. Excel automatically does this for you when you create the chart. You go customize the colors / symbols after the chart is generated by double-clicking on the line or symbols of each series.

Hope this helps

 

[gecc1]

Thanks dcnick....I'll try it out and let you know!

gecc1

 

[Greg Truby]

Have a look at Jon Peltier's tutorial on creating background shading by effective use of a 2-axis chart.

http://www.peltiertech.com/Excel/Charts/ColoredQuadrantBackground.html