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

Efficiency Chart...looking for some pop.

This is what I ended up with in the end, I appreciate all the help. The bullet chart might be a bit big but I was filling space until I thought of something else to add.


http://dl.dropbox.com/u/65191455/Final.xlsm
 
Hi hitmanwa,


I have tried to do something using 'Spark Lines', the graph produced is simple yet attractive. Please see the attached file. (If you can't see the graph line resort to the last sheet that has a screen shot of the same). I hope you will like it!!


http://dl.dropbox.com/u/60644346/EffSample_Reworked.xlsx


Regards,

Faseeh
 
Can any body help me to learn pivot table and dash board in simple version since my intelligence level is just average.


Thanks & regards


aratrika
 
Ahhh there' you go hitman. You're getting there.


Man, chandoo should do a post about this...


Aratrika: we'll help with whatever you want.
 
Aratrika


Please start a new threads for new questions which are unrelated to this thread


With regards pivot tables refer here: http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/
 
Thanks Hui! :)


@ hitmanwa,


Your last chart looks great, but when i try to change the dates from drop-down on top left, i goes to searching for some file and asks to open it? Perhaps it might be due to some linkage to file on your HD or so, overall it looks cool.


Regards,

Faseeh
 
Hui,


I can recall that few days back chandoo refereed how to make charts better and he refereed to some other site. I have tried searching for that post but am unable to locate it. I can remember one of the points: 'De-emphasize borders'. Can you locate the post. It might help hitmanwa.


Thanks,

Faseeh
 
Faseeh

The last chart style post chandoo made was:

3 days ago: http://chandoo.org/forums/topic/floating-camera-tool-picture

3 weeks ago: http://chandoo.org/forums/topic/making-different-excel-charts-on-the-same-scale


Chandoo often refers to Jon Peltiers web site : http://peltiertech.com/
 
Thanks all,


Here's an unprotected copy, I probably could have tightened it up a bit as far as the code and how everything is calculated and compiled but I'm still learning some of this.


http://dl.dropbox.com/u/65191455/Efficiencies.xlsm


You won't be able to update it because it pulls the data from 4 other files located on our network.


I didn't use sparklines, I wanted to, because some of our associates aren't on 2010 and my understanding is they don't show up on versions prior to 2010.


Thanks all,
 
pls load the File on Doc.google pls so we all can get help from it...

as i can only access doc. google due to office restrictions
 
You must log in or register to reply here.
Back
Top