Skip to main content

Questions tagged [data-visualization]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
29 views

Plot data set as an chart in Excel, and then add a second series showing the data's multiple standard deviation bands aligned to data values

I am working with a time series set of data which is the Rate of change between successive price changes in a historical section of a stock price. I have 59 observations. I have also calculated their ...
lvbx9's user avatar
  • 15
0 votes
0 answers
122 views

How to create Excel histogram from frequency table?

I have an Excel table with two rows. One header row with positive integers representing different event properties and another row with the frequency of events with said property number. Here's a ...
136's user avatar
  • 103
0 votes
1 answer
175 views

Which is the best graph to showcase 3 years of data grouped by weekly?

I want to present last 3 years of data grouped on a weekly basis. I have grouped the data in Excel on a weekly basis. I researched and found that a Box plot can be a good way of showing this kind of a ...
tunnelview's user avatar
0 votes
0 answers
96 views

How to create a line chart showing change over time in MS Excel?

I have snapshots of datasets and I want to create a line chart showing the change. For instance, each snapshot looks something like this (with different values): I wish to create a line chart showing ...
Shruti's user avatar
  • 1
0 votes
0 answers
3k views

In an Excel PivotTable, how can I sort by multiple row fields?

In Excel PivotTables, it's easy to sort, say, the rows by the major row field: There's a "Row Labels" column with a menubutton on the side, you click it, and you get sort options, just like ...
einpoklum's user avatar
  • 9,741
0 votes
1 answer
36 views

How do I generate a heatmap of the world with by-state data?

I have some dataset with pairs of the name of a state (not US state!) and a value (either categorical or on a scale). I would like to create a heatmap of the world, with the states marked on it, ...
einpoklum's user avatar
  • 9,741
1 vote
1 answer
53 views

Stacked bar chart to show asset maintenance types by year

I have a table of roads by year. The NEXT_ACTIVITY column categorizes the roads by the theoretical maintenance activity that the roads fall into. YEAR COUNT/TOTAL ROAD_COUNT NEXT_ACTIVITY ...
User1974's user avatar
  • 147
0 votes
1 answer
384 views

Graph multi-day data on a time series

I have a table consisting of (timestamp, integer) where the timestamps comprise readings over multiple days. I want to use this data to plot multiple time series on one graph such that it shows the ...
user1742188's user avatar
1 vote
1 answer
2k views

Remove trend line from a Power BI line chart with continuous x-axis

I need to remove the trend line from my Power BI line chart. The trend line was automatically generated and is not meaningful in my data analysis. I can't find an option to remove it. The trend line ...
Susie Derkins's user avatar
0 votes
2 answers
107 views

How to highlight trends in time records? (system errors)

I have a list of system error timestamps. I want to graph the time from the timestamps to see if there are any trends -- i.e. approximate times of day when the system often goes down. Question: Is ...
User1974's user avatar
  • 147
0 votes
2 answers
5k views

Excel: How to graph a multiple line chart by date and country

I have the following dataset that I would like to graph in excel.Dataset The data is from OurWorldInData.org if you need the full dataset. It has a country, date, and new cases columns. I would like ...
Moe's user avatar
  • 5
0 votes
1 answer
157 views

Microsoft Power BI desktop — columns col1 and col2 (from excel) make a chart with col2 y axis vs col1 axis

Microsoft Power BI desktop -- after importing excel columns col1 and col2 make a chart with col2 (y-axis) vs col1 (x-axis). Very much like the title says, after importing a spreadsheet from excel, ...
JosephDoggie's user avatar
0 votes
1 answer
205 views

Loop through visualization in power bi

So I want to have a visualization that is basically a table form, but with visualizations that loop for each customer, is there a control or visual that I can use to do this in powerbi? Please see the ...
Jakob's user avatar
  • 215
0 votes
1 answer
206 views

Creating an image from excel spreadsheet data

I have a spreadsheet representing 2D measurement data. Think of each cell's numeric value as a pixel intensity at (x,y) where x is the cell's column and y is the row. I would like to visualize the ...
Michael's user avatar
  • 337
0 votes
1 answer
160 views

Prevent the legend from being obscured in gnuplot's "dumb" terminal

Gnuplot's set term dumb is useful for visualizing data directly on a remote PC, where a GUI may not be available. However, I am seeing an issue, where the legend becomes obscured, causing the result ...
kdb's user avatar
  • 2,302
2 votes
0 answers
2k views

Create a "clock plot" in Excel

I'm not sure exactly what this kind of chart is called, but I'm going to call it a "clock plot" Basically I want to use it to visualize events that happen at certain times of day over say the course ...
audiFanatic's user avatar
0 votes
1 answer
74 views

Which libraries they use to draw a dynamic chart of "country’s GDP ranking history"?

I would like to draw a chart like this: https://www.youtube.com/watch?v=wykaDgXoajc Does anyone know which JavaScript libraries they use to realise this (e.g., changing year dynamically, changing GDP ...
SoftTimur's user avatar
  • 1,277
3 votes
2 answers
27k views

How to reverse Excel legend order?

I have an Excel graph (a stacked bar chart) where years are on the x-axis. The problem is that the order of the legend labels doesn't fit with the order of the values in the bars as shown in the ...
Karima Touati's user avatar
0 votes
0 answers
99 views

ELK - web page load time

I need to do some analysis on web pages stored in httpd server, I'm using ELK with filebeat and metricbeat but I don't find any way to visualize in kibana the page load time. Is there any way to do ...
michael's user avatar
1 vote
1 answer
458 views

Excel Chart Color - Create charts with conditional formatting on "text value"

I have a data set of Companies/Products with their performances for every quarter. I am creating a lot of graph to display the various performance. Problem: In order to be coherent, I'd like to ...
Guilu's user avatar
  • 11
1 vote
1 answer
541 views

Excel 2016: 3D column chart with transparency and no gap

I'm trying to make a decent-looking chart using a 3d representation of three different datasets (3 years, 12 monthly values). If I try with an area chart, I have peaks/valleys at the single data-...
guardiano's user avatar
1 vote
1 answer
194 views

When ploting 3d scalar field with Matlab, why axis X exchanges with Y?

When I draw the isosurface of a 3d scalar field A(i,j,k) (i=1~31, j=1~151, k=1~151) using Matlab, in the figure, indice j corresponds to X axis, i corresponds to Y axis. How does Matlab arrange 3d ...
user avatar
2 votes
2 answers
6k views

Add "Events" to a Time-Series Line Graph (Vertical line or x-y scatter)

I have an excel graph that displays price over time for a cloud service account, but I'd like to add on to it events that would change the pricing (ex: "Discontinued vm operation" or "cleared out ...
C Bauer's user avatar
  • 123
0 votes
0 answers
863 views

Is there a way to display live data using an excel file as the data source (without using any cloud service)

I'm trying to figure out a way that an Excel file (which resides on a network share) can be edited by users while a separate "display" computer simply displays that data and updates it in real-time or ...
George Kendros's user avatar
0 votes
1 answer
93 views

How to show numbers from another column over bars in the bar chart in Excel?

For the following data: Country | Calls with 3G | Calls with 4G | 3G Phone owners | 4G Phone owners US | 10 | 100 | 2 | 10 UK | 8 | 200 ...
Alexander Abramovich's user avatar
2 votes
1 answer
2k views

Visualising 3D data with a spreadsheet

Is there a (possibly spreadsheet?) program that enables manipulation of 3D data? The problem: There're several tables (A, B, C, …) Each table (an m x n matrix) represents measured quantities of a ...
sarasvati's user avatar
  • 123
1 vote
1 answer
15k views

Single data series with both primary and secondary axis (in two different units)?

Is it possible to plot (line graph) a single data series and display both a primary axis and secondary axis, showing two different units? Currently I have the different y-axis units as a separate ...
Dylan H.'s user avatar
1 vote
1 answer
2k views

How to visualize a point series within a grouped bar chart in Excel?

I have created a grouped bar chart within Excel, that shows the mean wage of men in different countries (y-axis), represented by different occupation groups (categories). Now I want to enhance the ...
user avatar
0 votes
1 answer
283 views

Graphing data points within a day

I have a spreadsheet that is a series of pings throughout a day and I need to visually represent that. I think a scatter plot is probably the best way, but I'm open to ideas and suggestions. When I ...
arb's user avatar
  • 3
0 votes
1 answer
219 views

MediaWiki word thesaurus graph extension

I use MediaWiki on Ubuntu. Is there a way to create word thesaurus graph from categories of MediaWiki? For example like this image:
hasanghaforian's user avatar
0 votes
0 answers
46 views

Combined diagram with area chart

[moved from stackoverflow] I have an combined diagram like this one: Is there a way to bring the red area into the foreground? I'm using Excel 2013, i.e. v15.0
Oliver's user avatar
  • 121
3 votes
1 answer
4k views

Add an area to a scatter plot in Excel

I'm desperately trying to layer an area chart on top of a a scatter plot in Excel 2013. The scatter plot has been successfully used to visualize the deviation from the mean of different Key ...
danpo's user avatar
  • 33
1 vote
2 answers
853 views

Finding the right graph to display inter-department connections [closed]

I have a task of displaying the interconnection between departments at my university. The idea is to show how many departments come together to work on a project. The data I have lists the projects in ...
user3616457's user avatar
0 votes
2 answers
85 views

Data modelling, calculation and visualization tools?

I often need to make decisions based on various kinds of data and their calculation results/visualizations respectively. For simple, tabular data I usually make Excel spreadsheets, however most of the ...
xvdiff's user avatar
  • 99
15 votes
3 answers
13k views

Create a video file from an audio file and add visualizations from audio

My initial thought was to upload audio files to YouTube along with video that is inspired from the audio. The particular visualization can be in different form such as spectrum, spectogram, or other ...
Sun's user avatar
  • 6,342
3 votes
1 answer
2k views

How to use ShemaSpyGui for view database diagram

I installed Postgre today and I want to watch database shema. I resolvse to use schemaSpy and download it and also schemaSpyGui and then I see: This is the command (password not displayed!) ...
gstackoverflow's user avatar
4 votes
2 answers
5k views

Software to use a spare monitor as a personal dashboard with custom data feeds? [closed]

I'm looking for anything that would allow me to use my third monitor for some neat data visualization. Ideally this would be running full screen, with focus on really nice aesthetics. I'm planning to ...
Underyx's user avatar
  • 951
0 votes
1 answer
89 views

How to view where the data are actually placed in an hdd's platter(s)

I have found some programs, but they just display the hierarchy of the files/folders in a sunburst chart. What I want is to view the data as they are actually placed/scatered in sectors/tracks of the ...
selfmade.exe's user avatar
0 votes
2 answers
131 views

Is there an application to link words between several documents? [closed]

I'm looking for a software in which I could insert a batch of text documents and then link words inside them. For example: I have doc1, doc2, doc3. doc1 is about animals, doc2 is about dogs, doc3 is ...
Unrul3r's user avatar
  • 321
0 votes
1 answer
3k views

How can I create a compound bubble and pie chart?

I'm looking for a way to create a compound bubble and pie chart likes this one: I know that ManyEyes could do it, but I don't want to upload my dataset to the public. How can I accomplish this?
user3212's user avatar
  • 101
1 vote
0 answers
505 views

Sites using nvd3.js for visualizations

I've recently started using a free javascript library called "NVD3.js" to build "interactive visualizations" for our commercial web applications. I'm thinking of applying it to our public web sites as ...
Okky's user avatar
  • 111
1 vote
2 answers
292 views

MySQL Data Visualization [closed]

I love data. I love watching it flow in and I love real time stats. I have a huge database for a webapp I recently created that is getting hit with a few hundred write queries per minute. Is there any ...
Peter Kazazes's user avatar
0 votes
1 answer
100 views

Display and analyze the graph of a website to check its connectivity and compute properties

I would like to check several properties of the graph behind a website I own. The properties I'm interested in are: diameter, shortest path from index page, min/max/average degree of vertices, and ...
alecail's user avatar
  • 720
0 votes
1 answer
588 views

Linux Process Lifecycle Timeline Graphing/Visualization

Is there a tool that will monitor the creation and destruction of Linux processes and generate data that would enable me to graph these events with respect to time? Or, alternatively, the tool would ...
Ray's user avatar
  • 145
2 votes
1 answer
136 views

Is there a means to keep an unlimited cross browser history?

Is there a browser addon or a webservice, which offers an unlimited browsing history? I'm looking for a better way to find things on the internet again and recognized, that bookmarking isnt enough! ...
jumper's user avatar
  • 273
0 votes
2 answers
2k views

Unable to create PDF graphics of Database layout using phpmyadmin

I have phpMyAdmin 3.4.2 setup on a Windows 7 system. And following versions of PHP and Mysql are installed - PHP Version 5.3.6 mysqlnd 5.0.8-dev - 20102224 - $Revision: 308673 $ (appears in the ...
Sandeepan Nath's user avatar
2 votes
6 answers
3k views

Good tools to visualize spreadsheets?

I have a few CSV and XLS files that I would like to analyse or "visualize" online (like in charts etc). I tried Google Fusion Tables, but I want to know if there are any alternatives. Also suggest ...
Irfan's user avatar
  • 241
1 vote
1 answer
631 views

Visualize tag cloud from keyword combinations

I have a csv file which contains keyword combinations(e.g consider "apple ipad" as one) in a cell. I want to visualize the csv file in a tag cloud form. Most online ones use only a single keyword to ...
iceman's user avatar
  • 2,450
5 votes
2 answers
3k views

Any alternatives to Ubigraph? [closed]

Ubigraph is a different way to create interactive user interfaces with the purpose of visualizing huge amounts of data. Its visualizations are simply stunning. The problem is that the project seems ...
David's user avatar
  • 1,279
2 votes
2 answers
6k views

Placing labels on data points in a stacked bar chart in Excel

Is it possible to place the labels not on the Y axis, but on the data point itself in a stacked bar chart in excel? I am trying to modify the timeline template available here so that my labels for ...
warren's user avatar
  • 10.2k