How do I create a 3D Bar Graph from the following data

**markmoss** · 02-21-2018, 11:24 AM

I have the following data in a .csv file that I import into Excel, once that is done I need to be able to create a 3D Bar Graph of that data.

Date, Time, Quantity

2/13/2018, 12:00 AM, 4.102
2/13/2018, 1:00 AM, 5.348
2/13/2018, 2:00 AM, 3.724
2/13/2018, 3:00 AM, 4.298
2/13/2018, 4:00 AM, 2.975
2/13/2018, 5:00 AM, 4.053
2/13/2018, 6:00 AM, 5.971
2/13/2018, 7:00 AM, 10.556
2/13/2018, 8:00 AM, 5.74
2/13/2018, 9:00 AM, 2.863
2/13/2018, 10:00 AM, 2.695
2/13/2018, 11:00 AM, 2.611
2/13/2018, 12:00 PM, 2.751
2/13/2018, 1:00 PM, 2.674
2/13/2018, 2:00 PM, 2.653
2/13/2018, 3:00 PM, 3.031
2/13/2018, 4:00 PM, 2.961
2/13/2018, 5:00 PM, 3.227
2/13/2018, 6:00 PM, 3.276
2/13/2018, 7:00 PM, 2.891
2/13/2018, 8:00 PM, 2.814
2/13/2018, 9:00 PM, 3.003
2/13/2018, 10:00 PM, 3.227
2/13/2018, 11:00 PM, 3.22

2/14/2018, 12:00 AM, 3.843
2/14/2018, 1:00 AM, 2.779
2/14/2018, 2:00 AM, 2.506
2/14/2018, 3:00 AM, 2.52
2/14/2018, 4:00 AM, 2.625
2/14/2018, 5:00 AM, 3.948
2/14/2018, 6:00 AM, 4.732
2/14/2018, 7:00 AM, 4.494
2/14/2018, 8:00 AM, 3.122
2/14/2018, 9:00 AM, 2.555
2/14/2018, 10:00 AM, 2.457
2/14/2018, 11:00 AM, 2.443
2/14/2018, 12:00 PM, 2.562
2/14/2018, 1:00 PM, 2.534
2/14/2018, 2:00 PM, 2.52
2/14/2018, 3:00 PM, 2.471
2/14/2018, 4:00 PM, 2.485
2/14/2018, 5:00 PM, 2.422
2/14/2018, 6:00 PM, 2.45
2/14/2018, 7:00 PM, 2.709
2/14/2018, 8:00 PM, 2.828
2/14/2018, 9:00 PM, 2.793
2/14/2018, 10:00 PM, 3.157
2/14/2018, 11:00 PM, 2.653

Quantity on the Left
Time on the Bottom
Day on the Depth ( the more days the deeper the Spreadsheet )

I have not been able to get it to display correctly as you can see in the attached Spreadsheet, I would like this datal to show on a single Graph.

Any help would be greatly appreciated.

**MrShorty** · 02-21-2018, 11:48 AM

To start, I would not use a 3D chart -- they are too hard to read accurately (if you want someone to really try to convince you against using a 3D chart: https://peltiertech.com/the-perils-of-being-in-3d/ ).

I find that a lot of charting questions in Excel are really spreadsheet how to arrange the data in the spreadsheet questions. In this case, the original text from the csv file looks like a decent database (except for the blank row between days), and I know that a pivot table will have the layout that I am looking for, so I would make a good database out of the csv file, then use a pivot table and pivot chart:

1) Remove blank rows between days from the data. (This may not be necessary, Excel may do just fine with the blank row. You would need to test if you are opposed to removing the blank row.)
2) Select the raw data table and
2a) Insert pivot table with
2b) Dates as the column labels
2c) time as the row labels
2d) sum of quantity as the values field.
2e) review this if you are unfamiliar with pivot tables in Excel: http://www.excel-easy.com/data-analy...ot-tables.html
3) select pivot table Insert -> chart -> column chart -> desired column chart subtype (I would use 2D clustered column, but you can specify 3D column here if you really want to).

**markmoss** · 02-21-2018, 09:16 PM

MrShorty,

I would like to thank you for your response to my question. Needless to it works great. I did have one follow up question, on the date labels is their a way to also print the day of week for that date, such as 2/18/2018 - Sunday or SUN ?

And if so how would I do this?

Mark Moss

**MrShorty** · 02-21-2018, 11:10 PM

Use a number format code that includes weekday (number format codes: https://support.office.com/en-us/art...2-09fab54be7f4 ). For example, something like "ddd m/dd/yy" would display as "Tue, 2/13/18"

Would something like that work?

**markmoss** · 02-22-2018, 01:30 AM

MrShorty,

Again I want to thank you for your kind help, this worked out Great.

I again have a follow up question on this Spreadsheet, if I add additional data to the data grid, is their a quick way to update the Graph so that this data shows up?

Mark Moss

**MrShorty** · 02-22-2018, 02:12 AM

If you define the source data for the pivot table in a way that it will automatically pick up the new data, it should be as easy as refreshing the pivot table (Pivot Table tools -> Options -> Refresh). I don't use pivot tables much myself, but strategies I see mentioned for defining an expanding data source for a pivot table include 1) Defining the source range larger than you will ever need, 2) Using Excel's "table" feature to define the source data as a table (which should expand as data is added to it) or 3) using dynamic named ranges. As a novice, it seems to me that there are many advantages to option 2 defining the source data as an Excel table. https://support.office.com/en-us/art...9-6c94334e492c

**markmoss** · 02-26-2018, 02:27 AM

MrShorty

After reading the article that you pointed me to and lookiing at several videos, I was able to use the Excel Table and hook up the pivot table to the Excel Table and then create the Pivot Graph off of that.

I want to thank you so very much for pointing me in the correct direction.

Mark Moss

How do I create a 3D Bar Graph from the following data

LinkBack

Thread Tools

Rate This Thread

Display

How do I create a 3D Bar Graph from the following data

Re: How do I create a 3D Bar Graph from the following data

Re: How do I create a 3D Bar Graph from the following data

Re: How do I create a 3D Bar Graph from the following data

Re: How do I create a 3D Bar Graph from the following data

Re: How do I create a 3D Bar Graph from the following data

Re: How do I create a 3D Bar Graph from the following data

Thread Information

Users Browsing this Thread

Similar Threads

Data which does not create a 3D bar graph?

Data which does not create a bar graph?

create graph od sales data

[SOLVED] Create a graph for the following data

cannot create a graph from the data

HOW CAN I CREATE A HISTOGRAM GRAPH FOR MY DATA?

[SOLVED] Can one still create a graph using data in the worksheet?

[SOLVED] How do I create a graph from an equation and not a set of data?

Bookmarks

Bookmarks

Posting Permissions