Questions tagged [charts]
Graphs, charts and other graphical methods for showing data and their relationships.
1,574
questions
0
votes
1
answer
33
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
57
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 ...
- 33
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 ...
- 133
1
vote
0
answers
41
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
42
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
46
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
31
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 ...
- 15
0
votes
1
answer
57
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&...
- 360
-1
votes
1
answer
130
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
1
vote
1
answer
55
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 ...
- 25
1
vote
2
answers
89
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=...
0
votes
0
answers
44
views
Align function plots with column values in Excel
I have an Excel file with data columns that contain tens of thousands of values and I want to visualize these values in a 2D-function plot
The way Excel does it is to orient the x-axis of the plot ...
- 103
0
votes
1
answer
24
views
Where is the Sparkline tab in the Show group for Excel?
How would I display the high points?
screenshot
Copilot says:
You Apply Blue sparkline color and display the high points for the
sparklines.
Copilot Certainly! Let’s create sparklines in Excel, apply ...
- 5
0
votes
0
answers
35
views
Best Excel chart for displaying discrete survey results
I have an Excel workbook containing results from a recent skillset survey. For every skillset, respondents could choose from Low/Medium/High or they just leave it blank.
What is the best chart to ...
- 481
1
vote
0
answers
22
views
scatter graph is not displaying the date correctly for each data point
dates in my data set in my worksheet are all of the format da-mon-yr
the dates range from 22-oct-21 to 11-mar-24
the dates are sparse and repetitive. IE :
22-oct-21, 01-nov-22, 01-nov-22, 01-nov-22, ...
- 31