• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help opinion on visual spreadsheet

Hello, Guys,

I've been working on creating a spreadsheet for cash flow control and I've been thinking about ways to make the spreadsheet more visual. I'd like to hear your opinions on this.

In the left column, I have the names of the information: sales, expenses, and the basics for controlling a small bakery business. Right below, I had the idea of putting a waterfall chart to give the person looking at it a better analysis. However, I'm not sure if it will really help or if it will just clutter the spreadsheet with unnecessary information.

The values are fictitious.
I welcome opinions on design (colors and table model).
 

Attachments

  • exemplo 1.png
    exemplo 1.png
    102.8 KB · Views: 7
  • Exemplo para Fluxo caixa e gráfico cascata.png
    Exemplo para Fluxo caixa e gráfico cascata.png
    112.1 KB · Views: 6
Difficult to say. And I believe it probably depends on personal preferences.

I once had a supervisor that lived for spreadsheet and charts. The more data presented the better he liked it. Everyone else in
the meeting room didn't care less.

One thing I noticed, your present data does not include the first half of the year. Those columns/cells are blank so the chart looks
sparse with content. Maybe fill in those blank months with sample data and see what the chart looks like then. Also, maybe the
current chart style is not the one you really need ? Try experimenting with other styles ... you may find one you like better.

My $.02 cents.
 
Back
Top