How-to Visualize 17000 Data Points of Upload and Download Times

Network Data Usage Excel Chart
Network Data Usage Excel Chart

In the last Friday Challenge, I presented you with 17,000+ data points representing 2 days of network data usage.

With so many data points, it may be best to visualize the data to see what is happening … and when.

Here is my what my chart looks like:

Network Data Usage Excel Chart
Network Data Usage Excel Chart

You can quickly make this chart with the following steps:

1) Highlight the Data





2) Insert a 2-D Stacked Column Chart

3) Change the “Download” Data Series Fill to Red

4) Change the “Download” Data Series Transparency to 50%

 

This is really easy when your Horizontal Axis has Text.  If your data is Date/Time format, your chart will look like this:



Network Data Usage Excel Chart - Date Axis
Network Data Usage Excel Chart – Date Axis

Excel charts your data like this because Excel thinks that you want to chart all the data by day, not time.  To see the time data, change your Horizontal Axis from Automatic to Text:

Network Data Usage Excel Chart - Text Axis
Network Data Usage Excel Chart – Text Axis

If you do that, then you will get the chart that you see at the top of the post.

 

Video Tutorial

Sample Data File

Here is the sample Data File:    Sample-Data-Network-Usage.xlsx





 

Do you have any other visualizations for this data?  If so, drop me a line in the comments section below.

 

Steve=True





LEAVE A REPLY

Please enter your comment!
Please enter your name here