All Questions
Tagged with microsoft-excel-2016 charts
94
questions
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
1
answer
30
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
0
answers
64
views
How to remove labels that values are equal to zero. I have a chart that has a lot of labels, but only a few have values 0<. How to display only values
I have an excel tower graph that is linked to a table that has a lot of categories. Most of these categories contain values that are 0 but may be changed to a value greater than 0 in the future. Since ...
- 1
0
votes
0
answers
71
views
Trouble creating vertical trendline on clustered bar chart in Excel 2016
I have 2 columns of data in Excel 2016. Col. A is a list of states and Col. B is a percentage. I've successfully made a clustered bar chart (vertically oriented list of bars) with A as the Y axis and ...
- 339
0
votes
1
answer
6k
views
Chart axis labels — Use $1M (million) short form instead of full $1,000,000 number
I have a PivotChart in Excel 2016 that has dollar amounts as the x-axis.
Currently, the labels are formatted as full numbers. Example: $1,000,000.
Is there a way to format the labels by replacing the ...
- 157
0
votes
1
answer
457
views
Excel: Plot a single X and Y coordinate in a static graph
I am trying to create a coordinate graph where the X and Y axis are in a static 1 to 4 scale and the values do not change. The point to be plotted is gathered from two formulas that calculate the ...
0
votes
0
answers
2k
views
Microsoft Excel - Why is my graph not plotting correctly?
I have two columns of data,
the first column is Average RT, going from 2050 to 20450.
My second column is fraction, from 0.000000 to various decimals, but all add up to 1.
My aim is to plot the ...
1
vote
1
answer
151
views
How to create an Excel chart of the following data
I'm trying to create an Excel line chart that would dynamically present the following data (this is just a sample, the data set is much bigger and is changing a lot):
Name | Salary change date | ...
- 13
1
vote
0
answers
742
views
Excel Secondary Axis being Stupid with Stacked Bar Charts
I hope you can help with this as it is the first time google has no result for an error I thought it was common.
I am following the instructions for a bullet chart, but instead of a column, I would ...
- 29
1
vote
0
answers
273
views
Use Same Scale for Axis and Bubble Sizes in Bubble Size Chart Excel
I've been dwelling on the Internet for a long time before understanding how Bubble Charts work in Excel. Now it seems logical to me that the Bubbles have their own scale to represent data in a way ...
- 21
0
votes
0
answers
153
views
How to find scatter plot point in the source data?
I have points in an Excel 2016 scatter plot chart:
I've hovered my mouse over a specific position in the chart.
The points at that position are possible outliers, so I want to look them up in the ...
- 157
2
votes
1
answer
3k
views
Excel graph not showing some x value labels
My x-axis for an Excel graph is missing some labels
and I cannot figure out why.
More specifically, my x-axis is supposed to look like this
(I will bold some of them so it's easier to read):
50, 100, ...
- 123
3
votes
1
answer
10k
views
How to Change Orientation of Multi-Level Labels in a Vertical Excel Chart?
I have the following chart and I am not able to edit the first level of labels (membership, chapters, etc). When I go to Format Axis -> Alignment I can only change the orientation of the second ...
- 119
0
votes
0
answers
69
views
Excel Chart "Save as Picture" making dates into numbers
I'm trying to save a picture of an excel chart (for use in distributions where it doesn't allow me to just copy and paste the chart). So I right click the chart I want to save, click "save as ...
- 21
0
votes
1
answer
347
views
Create multicategory timeline chart in Excel
I'd like to create an Excel chart showing on the x axis the dates from 1943 to 2021 and on the y axis the relevant category which follows a specific timeframe.
I.e. from 1/1/1943 to 18/01/1943 ...
- 3
0
votes
0
answers
588
views
Plotting country outlines in Excel map charts
I've plotted a map chart in Excel of UK counties that looks like this:
What I want is to be able to have an outline of the whole of the country, instead of lots of whitespace for where there is no ...
- 101
0
votes
1
answer
698
views
How to create a Line Chart with a scaled X Axis and Dummy Variables
I'm intending on creating a line chart with three Lines. The Final X axis will display the Values shown in column Time Period. But I am using the column Days as a dummy variable to get the axis spaced ...
- 127
0
votes
1
answer
98
views
Irregular label on Excel chart
I have an Excel chart with months on its x-axis. The first date is December 2016 and the last date is November 2020. I need these two dates to be seen,
but I can't have all the labels being seen (it's ...
- 103
0
votes
1
answer
2k
views
How to replace a numerical Scatter Plot axis with Text values
Please see below for my current graph and table:
I would like to replace the the X-Axis (0, 1, 2, 3...) with the corresponding letter grades in the table (B, B+, A-...) with no duplicates and still ...
- 127
0
votes
1
answer
2k
views
Total for stacked area chart
On a stacked area graph, is there any way to display what the total of all the series are for the last data point other than eyeballing that it looks somewhere around 115 in the example below?
I know ...
- 958
0
votes
0
answers
40
views
Quantile plot for multiple groups before and after treatment effect
I have a question on how to generate a comparative 95% confidence interval a round a median easily in excel. I have seven columns of data, representing 7 different users. I also have a column as an ...
- 1
1
vote
1
answer
2k
views
Excel chart, change axis tick's positions to specific integer values
I'm trying to move the position of all axis ticks to integer values while trying to keep the real scale (min and max values) of the axis as decimals.
The current position of the ticks are: 6.8, 7.8, 8....
- 11
0
votes
0
answers
55
views
Dynamically change charts from a drop down with a changeable data range
I will be straight to the point, aassuming you got a set of some measured data, and there in a Column A you got a product name, in Column B number of tests you did (always different) and third Column ...
- 121
1
vote
1
answer
6k
views
How to ignore column values under a certain threshold when making a chart in Excel
I have a column of about 14,000 populated numerical cells, and when graphing this column I would like to ignore all values that are less than 1000. These values are due to error in sensors and show up ...
- 11
0
votes
1
answer
3k
views
How to change the legend name in clustered columns chart in Excel
I am trying to update the legend name presented in a clustered columns chart that I create via a pivot table. There are few ways recommended online how to update the legend name for regular chart ...
- 103
0
votes
1
answer
446
views
Excel 2016 Chart > Date and Text on the same Axis
I received an interesting question yesterday during at work. Is it possible to have Date and Text values on the same Axis in Excel Chart, but that this "text" is actually formatted or somehow ...
- 121
0
votes
1
answer
537
views
Statistic chart in Excel: why there is one bin for the "Overflow"?
I have this "Statistic Chart" plotted in Excel, in which I set 25 as the "Overflow bin". But why there is a designated bin at 25 (highlighted in red square)? How to remove this? I just want to show ...
- 409
1
vote
2
answers
2k
views
Excel offers different options for markers in different runs - why?
When I look at the built-in marker options in Excel, on of my running sessions offers cross as an option, another one does not.
What could be causing this and how to fix this easily?
Using Excel 2016....
- 89
1
vote
3
answers
4k
views
Microsoft Excel: Extending the x-axis of a chart without disturbing existing vertical gridlines
I have 50 rows on my chart for the X-axis. Now I need to add 10 more rows. If I right click on the chart & click on "Select data" & then increase the Chart Data Range by 10 more rows, then ...
- 583
1
vote
0
answers
24
views
Create a bar chart showing percentage of users (by Unit Group) that access via A or B or either in excel 365
I have an excel spreadsheet that provides username, UnitGrp, AccessA (1 for yes, blank for no), AccessB (1 for yes, blank for no).
I want to create a bar chart that shows the percentage of users from ...
0
votes
1
answer
2k
views
Excel Graph - How can I graph time-series data with uneven measurement in format (other than x-y scatter)?
I'm trying to chart some vital sign measurements but don't want to use an x-y scatter... my issue is that the measurements were not taken at even intervals (not even close) and were taken multiple ...
- 1
0
votes
1
answer
359
views
Can I create "groups" in Excel histograms by adding spaces between specific bars?
I'm not sure if this is even possible, but I was hoping to create three visual groups in an excel histogram. More specifically, I was hoping to add a bit of space between the bar for 90% and 100%, and ...
- 103
0
votes
1
answer
3k
views
Add multiple Utilization (percentage) trend lines to a Stacked Bar Chart with a count
I would like to know how to put in percentage trend lines for individual levels in a stacked bar chart using the data below. I want a usage trend line for the total, as well as certain specific levels....
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 ...
0
votes
1
answer
5k
views
Keep the error bars in foreground in Excel scatter chart
Often in my work I place vertical scatter data inside a graph and overlay a single data point corresponding to the average of that group of data. When I place error bars on that average, the error ...
- 3
1
vote
1
answer
40
views
Excel: when combining column chart and line chart, position of the line
I am trying to obtain the following chart: for each month, a column chart representing the amount of money spent, and line chart representing the amount of money I had at the beginning of the month.
...
- 13
2
votes
1
answer
1k
views
Excel Chart - X-axis values stopping at a certain point
I really hope someone can help me with this as it's driving me crazy. I have a chart in Excel which is based on a series of dynamic named ranges. When I update the source data, the table extends and ...
- 21
1
vote
1
answer
577
views
Show when column exceeds vertical axis maximum
I've built a stacked clustered column in Excel 2016. I've manually set the maximum value of the vertical axis and several of the (combined) columns overflow. I want to provide some visual indication ...
- 121
1
vote
1
answer
595
views
Displaying number and percent in stacked bar graph with double Y Axis
I have multiple ongoing projects, with data in Excel.
Each project has zero or more issues associated with it,
as well as a percentage representing how complete the project is.
Each issue is of high,...
- 88
0
votes
0
answers
257
views
Making line chart respect time?
I have a line chart with dates as axis X, and there's a gap in the data (e.g. there's data until the 8th, then no data, then data from the 20th). Excel displays all this on the same scope, ergo the ...
- 197
0
votes
1
answer
911
views
Is it possible to create a chart based on a single cell that contains two separate numbers?
I'm currently combining two workbooks and then exporting a comparison of the data there. If I'm exporting a table this leaves me with something like so..
+----+---------+
| 1 | 2 |
+----+------...
- 63
0
votes
1
answer
16k
views
Make only one bar in bar chart stacked?
Is there any way I can create a bar chart based on data but make only one bar stacked? Like this (see the last bar):
I made this image by adding a shape to the last bar. Is it possible to create a ...
1
vote
0
answers
39
views
I want charts to preserve formatting when I chnge data
Suppose I want to make multiple similar charts within a single workbook. The only difference among the charts is the variables to plot. I can set up a range of multiple chart sheets and change the ...
- 111
1
vote
2
answers
3k
views
Excel graph where X and Y values are not in adjacent cells
I have this particular table and I want to have a plot of PAV vs Freq. But the problem is that since the cells are not laid out in a way that excel can understand (e.g. in a 2 adjacent columns) Excel ...
- 111
0
votes
1
answer
38
views
Is it possible to create a spreadsheet from a chart Excel
Exactly as the title says, is it possible to take a chart from say, Word, and then create a spreadsheet of its data in Excel. Specifically, I am asking in regards to 2016 for both.
For a bit of ...
1
vote
1
answer
82
views
How to plot data vertically with labels
I have a worksheet that looks like this:
What I need to do is to make a point chart where the Names are the vertical axis and the Dates are the horizontal axis. The points should have different ...
- 113
-1
votes
1
answer
2k
views
Excel how to scatter plot from tables
I have an Excel 2016 worksheet with three tables:
Table with X coordinates (multiple rows and multiple columns)
Table with Y coordinates (same number of rows and columns than X)
Table with labels (...
- 11
1
vote
1
answer
2k
views
How to get Excel to graph multiple series where series are "mixed" in a table? [duplicate]
I've got a table that contains multiple data series - and they aren't uniformly distributed either. Example below. As you can see there are multiple series here: Income, Short-Term Capital Gain, and ...
- 627
1
vote
1
answer
6k
views
Excel 2016 Chart showing random dates in x axis
I'm simply trying to graph some time-scale data using a date column and 3 data columns, but Excel keeps screwing up the dates in the chart... (showing dates from year 1900-1903 instead of 2018)
All ...
- 121
1
vote
0
answers
951
views
Excel 2016 waterfall chart losing data and formatting
I have a problem with a report I built and released into the wild.
It contains a waterfall chart with an offset within it linked to a spinner button to change the displayed data range on the fly. ...
- 63