1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

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

Dashboard file size

Discussion in 'Excel Dashboards' started by sms2luv, Aug 1, 2017.

  1. sms2luv

    sms2luv Member

    Messages:
    284
    I am creating a new dashboard.
    I want a designer look, I mean little modern look, with the help of shapes and colours

    If I pit my company data, the file size will become around 33Mb.
    I was wondering if I should put the data on a different excel sheet and just paste the output on anothee size.
    What do you suggest.
  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    10,704
    If you save the file as an Excel Binary file type (*.xlsb) does that help?

    You can export the dashboard part as say a PDF file, that will minimise the size for people receiving it, but they won't be able to modify the dashboard

    Adding shapes and especially pictures increase file sizes, are they essential? can they be removed?
  3. sms2luv

    sms2luv Member

    Messages:
    284
    Thanks, you gave the Info, I was looking for.
  4. sms2luv

    sms2luv Member

    Messages:
    284
    Can you help me with some link, where I can see some examples of Modern looking Dashboard
  5. chirayu

    chirayu Well-Known Member

    Messages:
    744
    That's what I do with my Dashboards. I have separate excel tools for calculation & paste final figures into my dashboard wherever I can. Saves file space.
  6. Hui

    Hui Excel Ninja Staff Member

    Messages:
    10,704
    There are loads of great dashboard Examples right here

    Use the Search Box on the Main Chandoo.org page and search for Dashboard or Dashboard Competition

Share This Page