Forum Discussion

abaken's avatar
abaken
Regular Visitor
3 years ago

Visual Options

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
Need Help

1 Reply

  • NikhilChenna's avatar
    NikhilChenna
    Skilled Sharer
    3 years ago

    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!