how to add i bars to graphs in excel for mac

Add I Bars To Graphs In Excel Software Articles For

How do I do it quickly I tried copyingpasting the data column into the graph, didnt work.

After adding to the selection, a dialog box pops up with leftright checkboxes, when I click OK some kind of new graph line is inserted.

I dont want to replace anything, just add the new column to the graph.

Click and drag the corner of the blue area to include the new data.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged excel excel-2013 or ask your own question.

You can customize Excel graph gridlines from the Chart Tools tab.

Click Insert and then select a line, column or bar graph that will have gridlines.

You can add more gridlines to the chart by selecting Layout Gridlines.

Then select either Primary Horizontal Gridlines or Vertical Horizontal G ridlines as below.

Select additional gridlines for the graph from the submenus.

You can select either major or minor gridlines for both the vertical and horizontal axis.

Select More Primary Vertical Gridlines Options or More Primary Horizontal Gridlines Options to open the window below.

There click Line Color and Solid Line to add alternative colors to gridlines.

Click the Presets box to choose a glow variation for the gridlines.

Select Shadow and click Presets to choose an outer or inner shadow.

Then adjust the shadows by dragging the Angle, Blur, Distance and Transparency bars left and right.

So with those options you can add more gridlines to Excel graphs highlighting data points in them.

In addition, the extra customization options will add glossy effects to your graphs.

Add I Bars To Graphs In Excel Software Articles For

Related Posts Previous Post Next Post Tags excel tips and tricks main Office Tips and Tricks Tips Tricks Tips and Tricks Windows Tips and Tricks About MatthewA Matthew is a freelancer who has produced a variety of software articles for sites such as Bright Hub and Captured Snapshot.

He has an A - Level in ICT, at grade C, and is proficient with a number of software packages.

Matthew also has a golf blog Check out his book at Battles of the Pacific War 1941 -1945 recalls where, when and how the Pacific War was won and lost within the battlefields of the Pacific.

We are part of the Azadi Network.

How To Add I Bars To Graphs In Excel For Mac