All Questions
Tagged with charts data-visualization
22
questions
1
vote
1
answer
38
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 ...
0
votes
1
answer
195
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
109
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
1
answer
426
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 ...
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 ...
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
159
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
222
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 ...
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 ...
0
votes
1
answer
76
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 ...
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 ...
1
vote
1
answer
487
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
545
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-...
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 ...
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 ...