All Questions
17
questions
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 ...
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
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
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-...
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
2
answers
860
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
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 ...
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 ...
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
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
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
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 ...