# Questions tagged [charts]

Graphs, charts and other graphical methods for showing data and their relationships.

1,584
questions

0
votes

1
answer

24
views

### Data series not displaying correctly in a scatter plot in Excel

I'm creating a scatter plot, tracking three data series. Each series is a data pair of two columns next to each other. The data in each cell is computed, with a formula similar to:
=IF($D8=$H$6, $E8,...

1
vote

0
answers

40
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:
...

2
votes

1
answer

104
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 ...

0
votes

2
answers

29
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 ...

0
votes

1
answer

24
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 ...

0
votes

1
answer

62
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:
...

0
votes

0
answers

21
views

### Google Sheets vs Microsoft Excel, charts and some problems [closed]

I have an array of cells that are odors of aromachemicals, EO, etc. (e.g. sweet, citrus, woody, floral etc.), and I want to do a chart that counts and shows the odors graphicaly with their numbers, ...

1
vote

1
answer

35
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

51
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

52
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

119
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

32
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

51
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

47
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

57
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

46
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

67
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

172
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

70
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

101
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

57
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 ...

0
votes

1
answer

41
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 ...

0
votes

0
answers

39
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 ...

1
vote

0
answers

25
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, ...

1
vote

1
answer

128
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 ...

0
votes

2
answers

124
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?

1
vote

1
answer

98
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; ...

1
vote

1
answer

128
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 ...

0
votes

0
answers

37
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 ...

1
vote

0
answers

30
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

71
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 ...

1
vote

1
answer

459
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

237
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 ...

2
votes

1
answer

626
views

### Reducing data points

I need to present data thats being stored per second over a whole day. So 86400 points per excel sheet. Creating a line chart from that isn't looking pretty and very slow, obviously.
To reduce data I ...

0
votes

1
answer

116
views

### Dot - Making large, almost arbitrary graph with labeled edges more readable

I have a (currently in-progress) directed graph that I am creating with Dot. The attached image is what I have so far. As you can see, it is hard to read because it is difficult to tell what labels ...

1
vote

1
answer

38
views

### How to plot data from separate files and axis intervals onto one chart?

I am running a simulation that exports data as a csv file(things like elapsed time, energy etc).
I have a few million rows of data (but only 5-6 columns), meaning I cannot actually open this file in ...

1
vote

2
answers

46
views

### Excel displays horizontal information incorrectly in graph

I have the graph below:
This graph should display a range of information on the Mohs and Knoops Hardness Scales
The Moh's data should be ranging from around 1.25-10, and knoop information from around ...

0
votes

0
answers

5
views

### How do you change the time format on the X axis in Garfana Cloud?

I know you can do it with the self-hosted Garfana by editing the config.ini files. How can I do this on Garfana Cloud?
Garfana Time Series Chart

0
votes

1
answer

442
views

### Excel - Target Line on Graph from just 1 Data Point

I am trying to chart out actual (performance) data points against target on a graph. Is there a way to produce the target line from just 1 value? It would be assumed all the performance variables ...

2
votes

1
answer

125
views

### How to select a repeating pattern of non-adjacent cells in Microsoft Excel?

I have an MS Excel spreadsheet having 603 records, each record having 27 rows and 4 columns for a total of 16,281 rows. My task is to create a line chart of the data (shock number from 1 to 603) in ...

2
votes

0
answers

103
views

### How to make graphic more or less detailed depending on zoom-level (similar to how Google Maps works)?

Not sure if this is the right site to ask this question. If not, maybe some admin can move it?
Are there some file formats (Or is this a software thing?), such as SVG or PDF, that supports reducing/...

0
votes

0
answers

43
views

### Vlookup with radar graph

i have a simple radar graph setup, 1 column for headings and 1 column for results. The graph works as normal until…
Id like the ‘results’ column to be auto filled using a simple vlookup formula. Such ...

0
votes

1
answer

63
views

### Excel Line & Scatter Graph - Plotting Scatter Points

Firstly apologies if I miss anything or get anything wrong, I am more familiar with StackOverflow than SuperUser. So please don't hesitate to ask for more details or to improve my question.
I am ...

2
votes

2
answers

669
views

### Excel: Adding secondary axis for one data set, NOT series?

I created a bar graph of the mean abundances of fish from several families across 3 different sites.
One family is significantly more abundant than the others and so I am trying to put all of that ...

0
votes

0
answers

84
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 ...

0
votes

1
answer

637
views

### How do I create an Excel pie chart representing a simple 12-hour clock?

I want to create a pie chart in Excel that represents a hand clock so that I can mark different time periods with different colors

0
votes

2
answers

802
views

### Excel chart to only show month when there is data

I update a table often, which powers a chart. It's a pain when after I enter the information into the table, I have to then fiddle with the chart and give it new dimensions so it displays the ...

0
votes

0
answers

89
views

### set data range automatically by skipping n rows when new data is added

I have multiple graphs in an excel. I would like to automatically set the data range when new data is added and refresh button is hit.
One example:
If there is a line graph with X -axis as date and Y-...

0
votes

1
answer

661
views

### Draw horizontal line on Excel chart without duplicating source value

When a horizontal line at given Y value between X1 and X2 values is needed on an Excel chart, it is a well-known trick to basically create a dummy source cell range where Y value would be mentioned ...