1. Welcome to the new Styleforum!

    We hope you’re as excited as we are to hang out in the new place. There are more new features that we’ll announce in the near future, but for now we hope you’ll enjoy the new site.

    We are currently fine-tuning the forum for your browsing pleasure, so bear with any lingering dust as we work to make Styleforum even more awesome than it was.

    Oh, and don’t forget to head over to the Styleforum Journal, because we’re giving away two pairs of Carmina shoes to celebrate our move!

    Please address any questions about using the new forum to support@styleforum.net

    Cheers,

    The Styleforum Team

    Dismiss Notice

The Excel Questions Thread

Discussion in 'General Chat' started by CunningSmeagol, May 4, 2009.

  1. Reggs

    Reggs Well-Known Member

    Messages:
    5,528
    Joined:
    Mar 11, 2006
    Location:
    The Internet
    

    Ok, so =TEXT(A1,"h:mm") was it. Thanks.

    I needed the cell contents to be literally numbers and a colon so I could use vlookup with another data set that would reference time and time zone, such as "8:00 Pacific"

    If you look around for excel help on time formats, everyone has issues with it.

    It's been some time since I've had a work project where I can just spend a few days with excel. It's very exciting and calming. I get so focused too. At this new job I'm using the latest version of excel. I'm very upset they took violet away as one of the default colors on the pallet. That said, I like the new deeper yellow. It's soft on the eye.
     
  2. borderline

    borderline Well-Known Member

    Messages:
    761
    Joined:
    Feb 8, 2008
    Location:
    SW U.S.A.
    I have an Excel chart question. I have a chart, it's an X-Y chart with numerous data points. In excel, when I hover over the data, it reveals the data source, that is, the cell values. I want to post a large version of this chart to a website, say a blog, and retain this capability. What are my options?
     
  3. otc

    otc Well-Known Member

    Messages:
    14,201
    Joined:
    Aug 15, 2008
    

    In native excel? I am not sure such a thing exists. Maybe in the cloud version of excel?

    Easiest way is probably to use google docs:
    http://www.webascender.com/Blog/ID/639/Embedding-Google-Charts-Into-Your-Website#.VaWa9flVhBc

    The example at the bottom looks like it does what you want.

    Otherwise, there are lots of other options like Tableau or various javascript/R packages that will do it.
     
  4. borderline

    borderline Well-Known Member

    Messages:
    761
    Joined:
    Feb 8, 2008
    Location:
    SW U.S.A.
    Sounds like using Google Charts is a better plan for web based interactive charts. Thanks for the tip, I'll see if I can figure it out.
     
  5. otc

    otc Well-Known Member

    Messages:
    14,201
    Joined:
    Aug 15, 2008

Share This Page

Styleforum is proudly sponsored by