All Questions
1,593 questions
0
votes
0
answers
26
views
How to stop Excel chart legend from overlapping the chart grid area?
How can I stop Excel chart legend from overlapping the chart grid area? No amount of clicking or dragging or digging through the menus solves this.
Excel for Mac
- 435
4
votes
3
answers
117
views
Excel: plotting a number of cases with two dots each connected by a line
Objective: creating a visualisation of a number of cases, each consisting of two points (x|y), and illustrating the difference between these two using a line
Example: a table that records the dates ...
- 145
0
votes
0
answers
55
views
How to render the data label over axis element of an excel chart?
Hello, I have a chart formatting problem which I cannot find a setting or solution for yet.
The issue is that the chart axis is rendered on a layer above the data label. I want to show the data label ...
- 103
0
votes
1
answer
31
views
Numerical coordinate for column chart X axis
I often create column charts with a scatterplot overlay to show individual points. However, I have to guess at the x values for the scatterplot. My formula for the x values is =(rand()/a) + b, where a ...
- 111
0
votes
0
answers
26
views
A graph with stacked column (3 data) with scatter points
example of a graph that contains stacked column with scatter points
How do I create a graph that contain a stacked column (3 data range) and a scatter points data as per image attached
12
votes
1
answer
883
views
In Excel, when I select data for a graph, how to prevent arrow keys from selecting cells?
For any given graph, when a data range is specified, is there a way to type with arrow keys that does not result in a different cell being selected?
For example in the images below, I'd like to ...
- 613
0
votes
0
answers
60
views
Creating a gradient colour in Pie Radar Chart
I want to create pie radar chart in Excel that represents the maturity level of 5 different fields (let's call them A, B, C, D and E) on a scale of 0-100. It's very similar to this problem - How to ...
- 101
2
votes
1
answer
59
views
How to generate multi-series bar chart with the legend using 3 column data in excel?
Sample data
Env
Server
Value
Prod
Server1
10
Prod
Server2
12
UAT
Server3
15
UAT
Server4
16
Expected output
I want the chart to show a
differently colored series for Prod and UAT servers.
legend ...
- 123
1
vote
0
answers
31
views
Using named ranges in charts without typing their name?
Is there any way in Excel to use named ranges in charts without typing their name? Something like the "Paste Name" window in formulas (available by pressing the F3 key)?
- 113
1
vote
1
answer
133
views
Quickly bring one line of spaghetti chart into focus in Excel
I have a spaghetti chart similar to this one:
I would like to take one line and make it "stand out", making the others less visible. Is there anyway I can do this quickly and easily (i.e., ...
- 179
0
votes
0
answers
20
views
linebreak skipping two lines on the title of my charts on MS Excel
I made a VBA code to create some charts and when I coded the title, I used the normal:
.title = studentname & vbCrLf & "Grades on test X"
but the output came out like this:
...
- 101
0
votes
1
answer
56
views
How to draw a line chart date versus letter grade?
I have an evaluation process that produces letter grades based on performance (A is best and E is worst). I periodically evaluate the process and produce the outcome as a letter grade.
Now I want to ...
- 101
0
votes
0
answers
76
views
How to overlay bars in a stacked bar chart in Excel?
I have two sources of data: Component data & Total data.
I would like them to both be shown in one chart in a "bar" format. The smaller (in magnitude) would have its color shown in the ...
ExcelQuestionAsker
0
votes
2
answers
103
views
Date and Time formatting in Excel is not recognised properly
I have been lurking for a while and trying to find a solution, but to no avail.
So the problem is that i have a column with the following data format of date and time. It's custom and exported from ...
-1
votes
1
answer
37
views
How do I set the upper and lower 95% confidence interval curves to red when generating Kaplan-Meier survival graphs in MedCalc version 23? [closed]
How do I set the upper and lower 95% confidence interval curves to red when generating Kaplan-Meier survival graphs in MedCalc version 23? I can not find and implement this function in the software.
...
1
vote
1
answer
90
views
How do I recreate this type of chart from screenshot in Excel?
I have chart like below. I am trying to recreate something like this in Excel. My call is to use XY chart, but I cant make it represent each row as different axis. Is this even possible in Excel?
Or ...
- 111
1
vote
0
answers
17
views
Applying Excel Custom Template Reorders Series
All I could find is a 2013 post on MS that is locked with no answers.
I've created custom chart templates, and when I apply them to an existing chart, they reorder the series. The templates apply ...
- 146
0
votes
1
answer
263
views
Data series not displaying correctly in a scatter plot in Excel
Original post below - updating starting a new chart from scratch with issue narrowed down.
Trying to create a "Stakeholder Matrix" as a scatter plot diagram. (Good overview article here).
...
- 3
1
vote
0
answers
166
views
Is it possible to draw percentile distribution graph in Excel?
Is it possible to draw a graph in MS Excel with reverse log X-axis for percentiles, so "ticks" on X-axis should be 90%, 99%, 99.9%, 99.99%, 99.999% and overall graph will look like this:
...
- 371
2
votes
1
answer
567
views
Excel - creating a chart using column data as x axis labels - how to set date intervals to yearly, rather than daily?
I am trying to create a simple line chart in Excel, using the data such as the following:
However, when inserting the graph using this data, the X axis is labelled with daily intervals, rather than ...
- 267
0
votes
2
answers
71
views
Is there a way to use the arrow keys to move chart elements in Excel and PowerPoint by individual pixel?
Is there a way to move elements using the arrow keys (or the keyboard in general)? I find that the 'snap-to' feature snaps to edges that I don't want, or I often want to move things and fine tune them ...
- 121
0
votes
1
answer
34
views
Excel Charts - Stacked Chart: Reduce Spacing and Combine Categories
I have the following data which produces the following chart:
I am trying to change the Axis so the month is shown once and the years data have no spacing between them, for example trying to only have ...
- 175
0
votes
1
answer
788
views
Chart shade of the area between two lines only when one is above the other in Excel
I'm trying to get a chart in Excel similar to:
where when my real values are under the plan there is a red area (i don't care when the real values are better than the plan). I've managed to get this:
...
- 3
1
vote
1
answer
54
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
...
...
- 153
1
vote
1
answer
95
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 ...
- 13
0
votes
0
answers
52
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 ...
- 307
0
votes
1
answer
271
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
1k
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 ...
- 45
1
vote
1
answer
42
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 ...
- 165
1
vote
0
answers
94
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
55
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
75
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
97
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
86
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&...
- 378
-1
votes
1
answer
605
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
118
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
200
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
84
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
77
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
54
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
41
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
1
vote
1
answer
170
views
Disable truncation of labels of treegraph in excel
I'm creating a treegraph in Microsoft Excel, but my labels get truncated unnecessarily. See the image below:
As you can see, the second digit of the labels of the smallest rectangles, which are the ...
- 129
0
votes
2
answers
219
views
Quick and easy way to plot a copied list of numbers as a line chart in MS Excel?
I have a copy pasted list of numbers.
I want to plot it in Excel as a line chart.
How can I do this, without having to add labels etc. to the data?
- 111
1
vote
1
answer
150
views
Added trendlines appear in legend but not in chart
I created a scatter plot chart in Excel and added trendlines, but they are not displayed even though legend entries are created. How do I make them show up on the chart?
These trendlines are ghosts; ...
- 303
1
vote
1
answer
152
views
Excel problems with axes data labels in dual clustered column chart
I have a dual clustered chart and I need to format the two Y axes, so they show a currency sign after the value but only on the highest value - not every single one.
What do I need to put into the ...
- 11
0
votes
0
answers
50
views
How to only plot a chart when both x and y cells are not blank
I have data like this:
A B C D
7 3 2
5 3 3
Cell A is X coordinates for chart1 and cell B is Y coordinates for chart1
Cell C is X coordinates for chart2 and cell D is Y ...
- 336
1
vote
0
answers
39
views
Having two modules on x-axis
I have a column chart on power bi with option OI against each strike and for each strike for all of the dates. So in short it has two layer in x-axis 1st layer is strike and 2nd layer is date.
For all ...
0
votes
0
answers
111
views
How can I easily make a chart showing what weeks a task was completed or not?
I'm trying to make a chart that shows who completed an inspection for each week. At my work, we run Sunday to Saturday and within that time period, we expect our guys to submit a truck inspection.
I ...
- 3
1
vote
1
answer
704
views
How to format Y axis in an Excel chart in days, hours, minutes?
I have an Excel chart tracking time taken to complete a task. I managed to use rows in my spreadsheet to apply custom data labels for the graph, but it doesn't match up to the Y axis of my graph.
I ...
1
vote
2
answers
239
views
How to change style of the x-axis?
This first picture is a recent line graph I created.
Notice how the x-axis has the year showing multiple times unlike the second line graph below. Is there a way to have the year show only once? If ...
- 113