Adding custom error bars in Mac Excel 2008

[patriceqsbqcza930]

I can't imagine that get a iphone4 but cost 0, come to join,friends! kDOaA 27go.info

[pnumwaan]

Thanks

[TiaLori91]

Hello, thank you for doing this. I have a bar chart with two bars for one series and when I select one bar only that one selects and I cannot get the Error bar option. Any Advice?

[svenypoodles]

How do you get the error bars to be specific to each column?

[Invinciwill]

Thanks mate, very helpful

[inviiincible]

This helped me so much, I was literally sitting at my computer for hours just trying to figure this out.

[SkyesAdventure]

There is no custom option when I do this.

[Loriixoxo]

Apparently I have Excel 2008 for Mac, just like you, but yet, the error feature in Format Data Series you speak of is not there for me. Any suggestions?

[Ellicat78]

Thanks, I've been meaning to look this up for a while now. Very clear explanation, Helped Heaps!!! thanks a lot!

[steezmonster92]

nice. key point was the holding command when selecting error values for the error bars. much simpler than the way I was taught.

[TheAmbiguousNinja]

I love you.

[JayMckable]

Omg thank you so so much

[lexuspsycho]

THANK YOU SO MUCH!!!!! THANK YOU THANK YOU THANK YOUUU!!!! I CAN SLEEP PEACEFULLY NOW :D

[xxpandafacexx]

LIFESAVER.

[tenshi0019]

Thank you so much! This helped me write my lab report. :) Your instructions were very clear.

[Myers3979]

@tenshi0019 It is 3 am and my lab report is due in the morning. This video literally saved my ass.

[Scrapbook15]

Thank you soooo much!

[boblenina]

If you want to get rid of the grid lines you simply mark them with the pointer and press delete on your keyboard. Easy!

[Kivinsky]

Anyone looking for the custom error bars needs to update to service pack 1. :D

[shantalrenee]

Thank you!

[dark0harlequin]

I have the same problem as ICYUNVME.

I am using the Mac 2008 version and it's registered.

There is no "custom error bar" option.

Any ideas?

Muchly appreciated!

[astonlagonda1]

thank you so much

[astonlagonda1]

Thank you so much

[RanaFraz]

Thanks for this video. To remove 'gridlines':

Right click the plot area- select gridlines- click line- click color- select 'no line'

[Druaga13]

Thanks for posting this

[ST3MSH08]

It was literally killing me. thank you.

[JJLiu920]

Thank you so much! You saved my life!!!!!! THANKYOu!

[nielsonpills]

This is fantastic, thank you so much!

[znoroozi]

Thank you so much.

[wjbean2290]

You are my hero, sir. I would kiss you.

[xxSuzumeChan]

Thank-you SO much. You saved my psychology assignment. Legend :)

[xiawei7909]

Wish I could this earlier!

[FallenSigil]

That was very helpful. Thank you!

[LimitedByCreativity]

Oh my gosh, thank you thank you thank you thank you thank you!!! I thought I'd have to do my graph for Biology all over again on a different computer before I found this video :') thank you so much!!

[liquidspacefreediver]

Thanks mate, I couldn't figure out how to get the individual error bars for each column.

[OMGDoraemon]

OMG, I must have spent many hours reading help threads to figure out how to add unique error bars for each column in the Win version of Office 2007, but they all gave crappy or incorrect answers. But just seeing your video made it so clear. I'm sharing this video to the rest of my lab. I love you, man!

[fireflower201]

Thank you so much; I could not figure out how to have different error bars for each data point.

[Anomis123]

Thank you!

[joshofcontempt]

but you forgot to mention that the option to customize error bars in the 2008 mac version of excel is a missing feature! how did you fix this problem?

[MITthuglife]

ok, so you have to update it..... BUT i did it yesterday and I had huge headaches since microsoft said I had an invalid product key which I did not, but I was able to fix it. Just make sure you are ready to go through that trouble. You probably have 12.0 this has 12.2.4 version, it takes a while to update it took about 1.5 hour running at 2.4mbps

[namaste19]

@joshofcontempt the custom error option is missing for me as well. what can i do to set the error?

[MrBlonde5k1]

To delete the gridlines, you can just click on one of them until they are 'highlighted' and press the delete key. (or perhaps function + delete).

[nashpl]

HI¡ I speak spanish, I have a problem with excel, I don´t know how autocomplete a name without a list. Thank you

[ohheytherelaura]

Oh my god I love you. This is so so helpful!

[russkeyuk]

Hi, I have Office 2008 and the File command at the top of the window has disappeared. Do you know how to get it back.

Regards

[ohiobiologist]

I am afraid I do not. Is it still gone after re-starting the application?

[ICYUNVME1010]

I have gotten to the step where you adjust the error bars in format data series, but when I bring it up my screen does not have the custom button, what do I do now ?

[ohiobiologist]

Are you using the Mac version? The newest windows version looks quite different, and the custom button can be harder to find.

[phiaable]

@ohiobiologist I'm having the same problem! I don't have the custom button either. I'm using the 2008 version for Mac. I do have a 'standard error' option but when I click it, all the error bars are the same and clearly inaccurate. Any suggestions?

This video was really helpful, by the way! Thanks!

[eniebylski]

@phiaable you need to download both sevice packs for office. They are available on the microsoft site

[Psylence6]

@ohiobiologist All of these people that are having problems with the Custom Values button is because they are missing the SP1 update for Excel. Go to Help --> Check for Updates and you will get the button with this update! Thanks for this informative video, too!

[tardigrada6000]

@ICYUNVME1010 I'm on the mac version as well, and having the same problem.

[elizze6]

@tardigrada6000 You need to download the SP1 pack, also known as the 12.1.0 service pack. you can get it for free off of microsoft's website.

[ohsooorad]

@ICYUNVME1010 Mine also doesn't have the custom button- I checked to see what version I was using and I am definitely using 2008 so I'm not sure what is wrong?

[ofthedeepgreensea]

thank you thank you thank you thank you. you have no idea how long i just spent trying to figure this out. my directions for my lab report only explain it an old version of windows. i don't know why they make this so complicated to do.

[ohiobiologist]

Thanks for the nice comment. I am glad that I could help.