• 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.

Multiple Data Series

niting

New Member
Hie forum,


What is the best way to depict multiple data series in one table and chart, like productwise, customerwise, yearwise, sales data.


I would appreciate any suugestions. I use open office and it does not have all functionalities of excel.
 

Hui

Excel Ninja
Staff member
Niting

Have a look through other peoples work either here at http://chandoo.org/wp/excel-dashboards/ or generally in Google


What does your business do now ?

What do your supervisors/bosses want ?

Theres no point inventing a sports car if they just need a family wagon.
 

niting

New Member
Hui,


Thanks for the link.


Dashboards are indeed great tool, but the extent of information and look of it is intimidating.

Still, thanks
 

Hui

Excel Ninja
Staff member
Niting

Don't be put off by dashboards

Start small

Add one chart adjacent to a second

Add components one at a time and only when you are comfortable with each step

Add formatting, text and other niceties to spice up (add value) to your growing dashboard.


Don't even be tempted with making them interactive or dynamic, that will all come with time


Start to realise that the most important thing with all dashboards is having your data organised.


Chandoo has a great tutorial on how to make a dashboard and it has some very good techniques to learn.

Work through it step by step and don't be afraid to ask questions here or in the post comments.

http://chandoo.org/wp/excel-dashboards/#how-to-make-dashboard
 
Top