All Questions
17
questions
1
vote
1
answer
37
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
193
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
421
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
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
158
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
221
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 ...
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
484
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
544
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 ...
0
votes
1
answer
295
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 ...
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 ...