Visual Options

[abaken]

Hi

I am a newbie..

I have for 30 drpartments the profit for each of the last 5 years. Management wants to see on one report the profit by  dept  for each of the 5 years. So dept 1 and its five profit results,  the same for depts 2 through 30 and all on one report.

Does anyone gavecz suggestion as to which kind of visual would be best

Thank You

• Allister

[NikhilChenna]

Hi @abaken ,

I think you shoud lgo with the area chart, clustered bar chart by taking the x axis as the years column and on the y axis take the profit number and on the legend take the department names,

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!