Questions tagged [charts]
Graphs, charts and other graphical methods for showing data and their relationships.
1,578
questions
0
votes
1
answer
21
views
How do I change the vertical axis on an Excel graph to display significant time periods? The gridlines are set at odd times
I would like the chart to reflect a 24 hour period and be able to choose the times displayed in the vertical axis
1
vote
1
answer
30
views
Excel: How to select a chart's data range using a corresponding value in another cell?
Let's say a DataSheet has the following data that is subject to change, including date headers. The number of columns is always the same. (Top left cell is A1.)
Name
Dec 1
Dec 2
Dec 3
Dec 4
Dec 5
...
...
1
vote
1
answer
44
views
How do I indicate nested data groups side-by-side in an Excel stacked column chart?
I am preparing a chart for an academic journal and am struggling with formatting.
In the original chart I am trying to reproduce, nested data for two year periods, 2017 and 2020/21, are displayed ...
0
votes
0
answers
39
views
Find Excel interpolated plot x value
How to find the x value to a function value (y) of Excel's default (interpolated) line plot (e.g. at the intersection of the horizontal line)?
Is there a built-in function to do so?
The error that a ...
0
votes
1
answer
38
views
How to create a single stacked bar chart with dual y axes in excel?
I have data pertaining to price-quantity bids are sorted according to price and looks like this:
I wish to plot a single stacked bar chart, something that looks like this image of single stacked bar ...
3
votes
2
answers
68
views
Can you combine stacked and clustered columns in an excel chart?
I am analysing failure modes of a machine using pareto analysis, but I keep adding more data and struggling to represent it correctly on the chart.
In the image linked below, the three bars represent ...
1
vote
1
answer
28
views
Can I create unequally spaced gridlines on an Excel scatterplot?
I am making a scatterplot with the following data:
Date
Value1
Value2
3/19/2024
5.31
45
4/15/2024
4.91
44
4/29/2024
4.93
44
5/13/2024
4.97
45
5/27/2024
4.71
42
6/9/2024
4.45
40
I created a ...
1
vote
0
answers
43
views
Excel is plotting scatter plot using the sequence of the points as the x-value and not the selected "x values"
I a trying to plot x and y values on a scatter plot with logarithmic axis. The x and y values are fairly random numbers, but when I try to plot them it plots the proper y-values, but the x-values are ...
0
votes
1
answer
44
views
Using Excel to make scatter plot reverencing all three axis to single point
I have three data sets. Speed, Torque and efficiency. I want to create a graph that shows relation between all three. So, like I want a point to reflect at what speed and torque what kind of ...
0
votes
1
answer
48
views
How to filter out the top 5 values of my data on my pivot table on a chart
I noticed that after filtering for the top 5 values, a blank one shows up and, when I go to filter out the blank, this doesn't work. My table and chart revert back to the original chart where all ...
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
64
views
Plotting data with missing points in Excel
Consider a spreadsheet for monitoring blood pressure. It has three columns: date, systolic pressure, and diastolic pressure. Each day, a new row is added. There's also a "Line with Markers&...
-1
votes
1
answer
146
views
I have created a chart in Excel but the percentage bar length is not increasing
I have created a chart in Excel but the percentage bar length is not increasing. All data is fine in chart, only the bars length is the issue.
1
vote
1
answer
61
views
How to display benchmark for each product in this stacked column chart?
See example data and chart below. I want to display the benchmark for each region on its corresponding column. How do I go about this? I have tried plotting the benchmarks on the secondary axis and ...
1
vote
2
answers
91
views
Automatically select series on scatter plot
Using Excel 365
Here's an example that I've been working on that gets pretty close to what I want: https://docs.google.com/spreadsheets/d/1zZiFDaUhuZAhyHm3HZkcZrUl9KEoV97N/edit?usp=sharing&ouid=...