Results 1 to 5 of 5
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    If you haven't seen this video I recommend it highly.

    So, I was inspired to see how far I could take excel in charting like his demo. You can see how far I've got with the attached file.

    I'm not ruling out VBA - in fact I think it will be impossible to replicate the functionality of his display without it.

    At this point I see two major problems with the chart.
    1) Labeling the bubbles with the country name
    2) Making the bubbles consistent from year to year. I'm not sure that the bubbles are using the same size scale from the beginning of time. Does this matter? I'm not sure since really the bubble size is a relative measurement anyhow.

    Turning on "tails" will require an intermediate data set and a separate chart I'm sure.

    What do you think?
    Attached Files Attached Files
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Just had a thought, if the source data is reorganized so that the header row is country.names that should cover the labelling issue.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ted Rules.

    I'd love to offer my assistance on this, however I'm stuck using '03. Nuff said. I'll be following this though, those are some truly impressive charts.

    *geek drool*
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Since a large group of countries is clustered near the bottom of the chart, the result of adding data labels is not very attractive:

    [attachment=85875:x.png]
    Attached Images Attached Images
    • File Type: png x.png (17.6 KB, 4 views)

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    [quote name='HansV' post='797083' date='09-Oct-2009 05:18']Since a large group of countries is clustered near the bottom of the chart, the result of adding data labels is not very attractive:

    [attachment=85875:x.png][/quote]
    Yeah, I notice that ultimately he grouped his countries by geographic regions and he had groovy popups instead.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •