Need Excel 2007 Help

Airplay355
Airplay355 Posts: 4,298
edited May 2009 in The Clubhouse
I made a bar graph and I can't figure out how to label the horizontal axis. In the old tried and trusted excel I used to be able to just select what data I wanted for the X axis but now when I go to slect chart data there's only a field for the Y axis and data range, neither or which do me any good. It pre-labels the bars with numbers, so I have bars labeled 1-5. I need to put pH values on the X axis so simply stating somewhere else that bar 1 corresponds to a value of 6.2 just seems dumb to me.

Does anyone know how to label the X axis in Excel 2007? I'm using a Mac, BTW but couldn't figure out how to do it on the PC version either.
Post edited by Airplay355 on
· Share on FacebookShare on Twitter

Comments

  • Airplay355
    Airplay355 Posts: 4,298
    edited May 2009
    Figured it out...Mac version sucks (figures) and the PC version had exactly what I needed. F$%&.
    · Share on FacebookShare on Twitter
  • xsmi
    xsmi Posts: 1,798
    edited May 2009
    Mac Version is '08 right?
    2-channelBelles 22A Pre, Emotiva XPA-2 Gen 2, Marantz SA8005, Pro-Ject RPM-10 Turntable, Pro-Ject Phono Box DS3B, Polk Audio Legend L800's, AudioQuest Cable throughout.
    · Share on FacebookShare on Twitter
  • wizzy
    wizzy Posts: 867
    edited May 2009
    Did you try OpenOffice (www.openoffice.org) instead?
    · Share on FacebookShare on Twitter
  • Airplay355
    Airplay355 Posts: 4,298
    edited May 2009
    Whoops you are right, it's 2008. I'm used to the campus computers which are Dells and have 2007 I think.

    I couldn't use open office because none of my friends have it and aren't going to download it. It was a group project so we had to be able to e-mail it back and forth. The older version of Mac excel could do it and the pc version could do it but for some reason they took that ability out of the 2008 version.
    · Share on FacebookShare on Twitter
  • wizzy
    wizzy Posts: 867
    edited May 2009
    Interesting ... I wonder why the PC version of OpenOffice can save/load Excel just fine but the Mac version can't.

    Are you sure?
    · Share on FacebookShare on Twitter
  • Airplay355
    Airplay355 Posts: 4,298
    edited May 2009
    I didn't think Open Office could save to a .xls or .doc file but no I never tried it. If you're sure I can still save to .xls and .doc then I'll try it.

    I don't have a problem opening .xls files, I can use Excel or Numbers to do that. I just need something I could save to and send to them. Sometimes the email servers at school filter our attachments that are "different" too so that causes issues. I can't send/upload Pages/Numbers/Keynote files using school e-mail. We have a **** tech department.
    · Share on FacebookShare on Twitter