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

Fun Charts

chirayu

Well-Known Member
Thought I'd start a thread to upload fun charts. Anything fun or creative or imaginative. See if anyone follows through with their own creations.

So here's my fun little chart. Utterly useless but fun nonetheless. Simple Column Chart, filled with image of beer & an overlay image of a beer mug. Password to unprotect sheet is 1.
 

Attachments

  • Beer.xlsx
    773.2 KB · Views: 6
Here's another fun chart, which is a basic 2D Pie Chart.
Password is 1
Things I changed:
- Fill Plot Area with pizza image
- No Fill for data series
- Add data labels & edit them to show Category Name & Percentage
- Add dashed line border of 1.5 width and white colour to data series
 

Attachments

  • Pizza.xlsx
    339.3 KB · Views: 7
@bobhc

Its like that song - Food, Glorius Food! lol

Here's another I made ages back. Its a stick man graph based on similar principles to the Beer graph.
Password to unprotect is 1
- Column chart axis fixed: min 0, max 1 (1 = 100%)
- All axis labels removed
- Fill series with the light brown colour
- Overlay image of man on top of chart
- Add a text box on top & do a simple =B4 so it always reflects the percentage
 

Attachments

  • Man.xlsx
    27.4 KB · Views: 5
Lovely Charting Chirayu,
How about adding a scroll ?
Man-Scroll.PNG

Regards,

P.S:
Ramazan here, we are fasting, can't take your pizza before sunset. :) lol
 
@Khalid NGO

A scroll can be added but I guess I just left it like that for users to manually type in.

Logically you can do a lot with these like add a vlookup from a hidden sheet.

For example for the 'Man' chart. Use it in a HR Headcount report.
Do 3 charts, one with green fill for retained.
1 with red fill for attrition, 1 with orange fill for new hires.
Then do a vlookup table in a hidden sheet for month on month performance & link the values to the charts.

Possibilities are endless. I was just posting fun charts though lol instead of thinking of application
 
Back
Top