Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Line Graph Help

Status
Not open for further replies.
Dec 16, 2008
83
GB
Crystal 2008

Hi, i need to create a stacked line graph in my report showing the number of policies by year of account. What i would like is the months of the year at the bottom with a running total up the side. Then multiple lines for the years, ie 2007 and 2008. I've tried playing around with the chart expert but the best i can get is a continuous line running from Jan 07 to Dec 08. Is there any formula or technique that would allow me to cut this?
 
Its ok, i've worked it out. I just created a formula called {@Month} which extracted the month out of the field i was using on my report and sorted in the chart expert on change of this month formula.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top