Questions tagged [data-visualization]
The data-visualization tag has no usage guidance.
51
questions
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 ...
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 ...
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 ...
3
votes
2
answers
28k
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 ...
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 ...
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!) ...
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 ...
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 ...
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 ...
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 ...
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!
...
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 ...
1
vote
1
answer
54
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
...
1
vote
1
answer
542
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-...
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 ...
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 ...
1
vote
4
answers
818
views
XY Diagram/Data Browser for mid-sized CSV files
I have a set of CSV files with about a 100k records in them. The records need to be visualized in an x-y diagram.
Specifically, I'm looking for:
Seamless zooming in and out of the data
Navigation ...
1
vote
2
answers
857
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 ...
1
vote
1
answer
633
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 ...
1
vote
1
answer
30
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 ...
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 ...
1
vote
1
answer
469
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 ...
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 ...
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 ...
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 ...
0
votes
1
answer
400
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 ...
0
votes
2
answers
114
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 ...
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 ...
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, ...
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, ...
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:
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 ...
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 ...
0
votes
0
answers
125
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 ...
0
votes
1
answer
178
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 ...
0
votes
0
answers
102
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 ...
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 ...
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 ...
0
votes
1
answer
208
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 ...
0
votes
1
answer
214
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 ...
0
votes
1
answer
162
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 ...
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 ...
0
votes
0
answers
100
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 ...
0
votes
0
answers
873
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 ...
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 ...
0
votes
1
answer
288
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 ...
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
0
votes
1
answer
91
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 ...
0
votes
2
answers
132
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 ...
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?