{"id":6256,"date":"2015-02-12T14:47:07","date_gmt":"2015-02-12T22:47:07","guid":{"rendered":"http:\/\/www.podfeet.com\/blog\/?page_id=6256"},"modified":"2017-07-31T13:30:10","modified_gmt":"2017-07-31T20:30:10","slug":"how-to-make-2d-excel-graphs-look-3d","status":"publish","type":"page","link":"https:\/\/www.podfeet.com\/blog\/tutorials-5\/how-to-make-2d-excel-graphs-look-3d\/","title":{"rendered":"How to Make 2D Excel Graphs Look 3D"},"content":{"rendered":"
\n
\n
\n

1. Problem to be solved<\/h3>\n
\n

Flat 2D graphs are boring, 3D graphs are hard to read. 2D graphs made to look 3D are the best of both worlds. \u00a0We’re going to do is add a 3-color linear gradient to the bars and then if desired throw in a background texture to add a little more depth.<\/p>\n

Experiment with the colors yourself and the background texture to get something that appeals to you, but most importantly makes your data easy to read so you can make your point with the graph.<\/p>\n

And yes, I know, Excel calls them charts but they’re graphs, darn it!<\/p>\n

This tutorial was created using Office 2011 for Mac.<\/p>\n<\/div>\n

\n
\n

1.1 Flat 2D Graph<\/h4>\n
\n

Boring!<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

1.2 3D Graph<\/h4>\n
\n

<\/p>\n

Confusing! Can’t read the heights of the bars accurately.<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

1.3 2D Graph Made to LOOK 3D<\/h4>\n
\n

2D graph is easy to read the values, but the shading makes it look three dimensional.<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

2. Create the Initial Graph<\/h3>\n
\n
\n

2.1 Select Data Range<\/h4>\n
\n

Select Data Range and then tap on the Charts tab.<\/p>\n

Alternatively you can select Insert\/Chart… from the menubar.<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

2.2 Select Chart Type<\/h4>\n
\n

Tap on Column in the Chart Menu and then choose 2D Column\/Clustered Column<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

2.3 Flat, Ugly 2D Graph<\/h4>\n
\n

Double tap on one of the blue bars. \u00a0Alternatively you can tap once on a blue bar and select Format\/Data Series…<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

3. Format the Bars<\/h3>\n
\n
\n

3.1 This Brings Up the Format Data Series Options<\/h4>\n
\n

Select Fill from the left sidebar (if it isn’t already selected) and then tap on the Gradient Tab.<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

3.2 Choose Linear from the Style Pulldown<\/h4>\n
\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

3.3 Default Goes from blue to white<\/h4>\n
\n

In order to produce the illusion of 3D, we want the bars to be a darker blue on the left and right, with a light blue in the middle.<\/p>\n

The default gradient only has two colors, so we need to add a color to the middle and then change the three colors to the desired dark\/light\/dark. \u00a0Select Add Color.<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

3.4 Change the Center Color<\/h4>\n
\n

Note the three pointers below the color gradient. \u00a0You can tell the center color is selected because the center pointer is highlighted. \u00a0Tap the Color pulldown.<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

3.5 Select a Lighter Blue for the Center Color<\/h4>\n
\n

I like Accent 1, Lighter 60% which is the second light one below the darker blue.<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

3.6 Select the Right Pointer<\/h4>\n
\n

The left color is already the darker blue color, the center is a light blue so now we need to change the right color to the same darker blue as the left color.<\/p>\n

We now need to repeat the process for the right color. Select the right pointer, and again click on the Color pulldown.<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

3.7 Choose Dark Blue for the Right Color<\/h4>\n
\n

Click OK.<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

3.8 You Now Have a Fake 3D Bar<\/h4>\n
\n

Rinse and repeat for the red bar<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

4. Background Texture (Optional)<\/h3>\n
\n
\n

4.1 Add a Background Texture<\/h4>\n
\n

Double tap anywhere in the background area of the graph. Alternatively you can choose Format\/Chart Area… from the menus.<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

4.2 Select Picture or Texture<\/h4>\n
\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

4.3 Select Texture<\/h4>\n
\n

I favor White Marble for the background.<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

4.4 Change Transparency to 50%<\/h4>\n
\n

The default texture is a bit distracting so I dial the transparency up which mutes the effect a bit.<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n

5. Our New and Improved Graph<\/h3>\n
\n

Celebrate!<\/p>\n<\/div>\n

\n
\"\"<\/div>\n<\/div>\n<\/div>\n
<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

1. Problem to be solved Flat 2D graphs are boring, 3D graphs are hard to read. 2D graphs made to look 3D are the best of both worlds. \u00a0We’re going to do is add a 3-color linear gradient to the bars and then if desired throw in a background texture to add a little more […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":4374,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[],"tags":[150],"class_list":["post-6256","page","type-page","status-publish","hentry","tag-mac-tutorials","post"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/pages\/6256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/comments?post=6256"}],"version-history":[{"count":3,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/pages\/6256\/revisions"}],"predecessor-version":[{"id":12363,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/pages\/6256\/revisions\/12363"}],"up":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/pages\/4374"}],"wp:attachment":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/media?parent=6256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/categories?post=6256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/tags?post=6256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}