Viewing 5 posts - 1 through 5 (of 5 total)
  • Mac users with Excel- help!
  • munrobiker
    Free Member

    The girlfriend has a Macbook and is trying to change the names of her variables in the legend- when she clicks it it just comes up with the option to change the colour of the variable’s points and line.

    Apparently it’s totally different to how it works on a PC- I know how to do it on a normal computer, but Office for Mac isn’t the same.

    Cheers!

    mrmo
    Free Member

    which version of office are you running?

    comedyphil
    Free Member

    If it’s anything like Excel 2008 that i’m running, here’s how I did it:

    You need to label the data sets you’re using, and it’ll appear in the Legend. You can do that by clicking on Edit in the Chart Data bit of the formatting palette in the toolbox. That’ll bring up a window much like that in the Windows version, where it shows where the data used to plot the chart is coming from, and one of the boxes there is “Name”. Pop what you want in there and it should change the legend too.

    HTH

    munrobiker
    Free Member

    Thanks so much Phil!

    comedyphil
    Free Member

    No worries

    It’s easy when you know how, incredibly frustrating when you don’t!

Viewing 5 posts - 1 through 5 (of 5 total)

The topic ‘Mac users with Excel- help!’ is closed to new replies.