# Questions tagged [charts]

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

1,452
questions

0
votes

1
answer

13
views

### When making a chart, how can I split values into series based on some other column value?

I want to make a chart of bw(qnb), split into 2 series. One serie where offload=0, one where offload=1.
Is there a way to specify a filter when defining a series?
If I select the whole column it will ...

0
votes

0
answers

23
views

### How to combine time interval data on excel

I have a set of data for internet usage for two people. For each person I have each time they logged in and out of the internet over a day. I want to make a bar chart/histogram where the x axis is ...

0
votes

1
answer

23
views

### Wrong order of intervals in Pareto chart

I have some table with 2 columns of data. First one is project id, other is Time To Market in days (finish date minus start date). Smth like:
Id
TTM
ID-1
23
ID-2
11
ID-3
167
ID-4
2
ID-5
40
I'm ...

0
votes

1
answer

16
views

### Line Chart vertical grid lines only for aggregated values (days, instead of hours)

I have two columns: day of week, hours (for each day) and number of things occurring on each hour of a specific day of week.
Below an example with first two days:
I want to plot these data as a line ...

0
votes

2
answers

26
views

### Excel Chart: multiple datasets having significantly different numbers of digits

I want to show a comparison between number of orders and dollars of shipment track against the cost.
I want to make a chart using this data, however, the numbers have huge differences to put them into ...

1
vote

0
answers

27
views

### Trying to create a line chart for multiple Vendors/Products

I have a worksheet that looks like this:
This is just a sample. The full sheet includes multiple dates and vendors. On a separate sheet I am trying to create a line chart with the following features:
...

1
vote

2
answers

28
views

### EXCEL: chart numerosity of items along time based on start-end date

I don't know how to explain better my case so I will go strait to the practical example:
I have this excel table:
Computer
Date Start
Date End
Server1
2022-01-01 00
2022-02-10 00
Server2
2022-01-02 ...

0
votes

1
answer

43
views

### Trying to make an Excel usage graph user-proof

I'm a stationary engineer in a large commercial facility. Recently we had a spike in our utility billing, and my boss wanted me to improve our tracking of usage so that we don't get surprised again.
...

1
vote

1
answer

49
views

### Create a histogram in a cell based on condition

I need a histogram in a cell based on condition.
Example:
In:
Input
My Out:
My Output
Needed Out:
Needed Output
So, If I'm using conditional formatting and choosing histogram, I have no option to ...

0
votes

1
answer

37
views

### How to edit legends of a chart from cell range

I have a list of legends and plot data in separate file. When I plot the data it creates legends as series1, series2, and so on. Now I want to replace the legends from cell list in other file. I can ...

1
vote

0
answers

37
views

### Force Excel charts in Word documents to use system separator in Windows 11

For my work, I need to use different decimal separators in Word (",") and Excel (".").
Previously, I could set that up as follows (Windows 10):
For Word documents, set ",&...

1
vote

1
answer

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

1
vote

0
answers

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

0
votes

1
answer

47
views

### How to create a 4-axes chart in Excel?

4 parts to the chart: Time to expiration, Implied Volatility, Stock price, Greek 'ABC' (the plotted value).
Ideally, it would have Implied Volatility (IV) on the Z-axis, stock price on the X-axis, ...

1
vote

3
answers

49
views

### How do I create this kind of step chart in Excel?

I'm trying to make a chart like the image below. Essentially, two companies are splitting a share of profits, but the actual share they're splitting is different depending on a specific threshold. I'm ...

1
vote

2
answers

30
views

### Excel - Stacked Scatter Plot - digital signal timing

I am trying to graph digital signals on a graph to show the timing breakout of each. Everyone except one signal is going to be a 1 or a 0. There is an additional that can be an integer, it would be ...

1
vote

1
answer

180
views

### Stacked Waterfall Chart with Positive and Negative Values in Excel

I am trying to create a stacked waterfall chart in Excel that behaves this way when there are positive and negative values:
(taken from here: https://peltiertech.com/charts-for-excel/split-bar-...

3
votes

2
answers

61
views

### Values on a simple 'number line' chart in Excel

I have 5 dynamic values:
MIN
MID
MAX
Actual
Target
100
150
200
119
144
I need a simple visualization (chart I guess) that is a 'number line' from MIN till MAX with markers on MID, Actual and Target ...

1
vote

2
answers

70
views

### Creating a floorplan in Excel using an X-Y scatter

I have a bunch of X and Y coordinates, and I would like to make a floorplan out of it. For that, I'm using an XY-scatter. This is working fine, but I would like to have the names of the nodes on top ...

1
vote

1
answer

53
views

### Remove trend line from a Power BI line chart with continuous x-axis

I need to remove the trend line from my Power BI line chart. The trend line was automatically generated and is not meaningful in my data analysis. I can't find an option to remove it. The trend line ...

1
vote

0
answers

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

1
vote

2
answers

66
views

### Is there an excel function to make a spine chart (Public Health England Profiles)

I am trying to create this kind of range graph (Public Health England is calling it a "spine graph". Is there a way to create this? The website allows us to export a raw data which includes ...

1
vote

0
answers

31
views

### Excel 2007 line chart won't add dates past 2014 when using full data range

For reference, the Excel file in question: https://ufile.io/mlczqpkb
When I try and include the entire range of dates and river heights, it always cuts it off at 2014. If I slide the ranges down a few,...

1
vote

0
answers

38
views

### How to Hide Series Name Label, Call Out Box & Zero Value in Chart?

I've seen a variant of this question asked a number of times, but none seem to deal with my particular problem. In my stacked bar chart I use a Series Name label. I'd like it to go away altogether ...

1
vote

1
answer

51
views

### Excel: How to not display labels in pie chart that are 0%

I have some data in excel that I want to graph in a pie chart (see image 1) where the text will be the labels and the numbers will turn into percentages. The problem is, when i go to graph the data, ...

0
votes

1
answer

124
views

### How to show a label of the last log from Google Cloud Platform's "Logs-Based Metrics" instead as a value (!) in Grafana? How a second last one?

I am passing a csv from one server to the other and add the number of rows to the logs by logging a jsonPayload with gcloud_logger.log_struct(....
I created Google Cloud Platform Logs-Based Metrics ...

1
vote

0
answers

20
views

### Graphing coordinates in Calc using direction, distance, and speed

Suppose I have the following data:
Location
Direction (Degrees)
Distance
Speed
Origin
N/A
N/A
N/A
A
090
5
50
B
180
15
75
I can make a chart using the following data to show the path something ...

1
vote

0
answers

13
views

### Clustered column chart for year over year quarterly data, improper spacing(pivot table)

How can I group columns in Clustered column chart for year over year quarterly data(pivot table)? In the example, I wish to have 2016 and 2017 values for a particular month grouped together for proper ...

0
votes

1
answer

55
views

### Graph/Chart based on amount per price

I want to draw a block graph line and it should show me the amount each block has and that the total equals to a certain number.
Example: Sheet example
I have 5000 items and would like to sell them ...

1
vote

0
answers

81
views

### Excel stacked-column chart hide columns with zero/NA value

Can Excel hide columns in a chart when the columns have 0, empty, or NA value? I have data like this:
If I select all the data and insert a stacked column chart, I get the following:
And if I change ...

1
vote

1
answer

163
views

### How to add confidence interval VALUES on an Excel graph?

I've created a "stacked line with markers" on Excel. Is there a way to label each marker point with its confidence interval values? The confidence intervals are so large than showing them ...

1
vote

1
answer

17
views

### Reading values from a standard graph in Excel for an automated calculation

I am building a spreadsheet calculator for my work and with the standard I am using for the backbone there are 2 graphs that are used in the calculation process. I am struggling to think of a ...

0
votes

0
answers

17
views

### Excel Combo Graph (Line primary axis, Bars secondary axis). Bars overlap vertically and do not display graph proper values

I'm looking for help on an Excel Combo Line (primary axis) and vertically stacked bars (secondary axis) barchart.
The data is pulling points correctly from the data table and displayed as the labels ...

2
votes

1
answer

169
views

### Draw sunburst chart with multiple columns

I have an Excel document that looks somewhat like this:
Type
Amount
Days without
Days with little
Days with lots
Tolerable
5
148
271
206
Less tolerable
4
295
162
258
A little intolerable
9
195
234
...

0
votes

0
answers

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

0
votes

0
answers

25
views

### Excel horizontal bar chart cannot format axis as dates

I am using Excel 365 MSO 64-bit. I am creating a horizontal bar chart. I right-click the x-axis and go to Format Axis --> Axis Options. There should be an "Axis Options" category, but it ...

0
votes

1
answer

45
views

### How can I reproduce this chart?

I am working on reproducing the chart attached. The chart shows the interquantile range of some countries for the categories shown on the y-axis, for the two year 2008 and 2018. Any idea how can I do ...

0
votes

1
answer

26
views

### Complex scatter chart

Not sure if this is actually complex, but I can't seem to get my graph to include a legend, sourced from column D. Attached is my attempt and the data.
Essentially It looks great now, but when I add a ...

1
vote

1
answer

22
views

### Selecting Excel chart template according to formula

While trying to streamline a part of a reporting job, I encountered a problem.
My aim is to represent the answer to several questions through the appropriate chart template for each of them. Let's say ...

1
vote

0
answers

121
views

### How can I create a 24-hour time period "occupancy" chart in Excel?

(First time posting, long time lurking, thanks!)
I'm trying to create a time series of site 'occupancy' - Basically, how many people are logged into the site over a given time period. Along the x-axis ...

0
votes

1
answer

28
views

### Excel - Stacked Cluster X-axis label has extra space at end?

I don't know why my chart has an extra line in my last Year of data... I added an extra space at the end for a buffer for spacing/presentation, but can't figure out why that line is still there!
Any ...

0
votes

1
answer

38
views

### How can I turn this list of values into a stacked (and combined?) bar chart where every value is shown per day?

I have a list of values with an amount and a date.
I would like to display it like a stacked (?) bar chart where each value is marked with its own box, and then displayed on the corresponding day – ...

0
votes

0
answers

13
views

### Open Office Calc - Create graph from each nth row

I try to create a graph from this table:
I need to select each row where Age group is 10-59.
Is this possible, or do I have to delete all the other data?
Attempts:
I tried to apply a filter and then ...

1
vote

1
answer

60
views

### multi column bar chart excel

I am working with data from a questioner in two columns that are linked and that I want to display in a bar chart. The first has ages ranging from 18 to 24 and the second has yes no maybe and dont ...

1
vote

1
answer

36
views

### Embedding a vertical reference line in chart

I am using a combo chart and I have managed to reach as shown below
Below is the output that I am seeking. I am trying to add a vertical line for a specific date (say 11th Jul)
I googled a lot but ...

2
votes

2
answers

22
views

### Excel charting numeric values as labels

I am trying to represent ages of a population as a bar chart I've ,ade itby using a pivot tabel so I've also split the bars by sex.
Excel is charting the age as a data label, but I want to treat it as ...

3
votes

1
answer

153
views

### Datalabels are missing in dynamic chart

I am trying to create a dynamic chart but the data labels are missing. I add the data labels manually to all headers and then save and close the file. When I open the file and select a different ...

1
vote

1
answer

56
views

### Plotting Non-Contiguous Time Onto a Chart in Excel

I was given a spreadsheet with dates and timestamps of when one of our systems went down and came back up with the task of creating a visualization of the data. The Date and Timestamps were embedded ...

2
votes

1
answer

58
views

### Excel Gantt chart: time line fixed start 1st each month in major steps?

I am using this an excel Gantt chart like this one, to name any: https://www.vertex42.com/Files/download2/themed.php?file=project-task-list-with-gantt-chart.xlsx
No matter what I try, the Gantt chart ...

0
votes

0
answers

6
views

### Can I control how many colors are used to cycle through the series in macOS Numbers?

I have a spreadsheet in Numbers that has a column of data for each day of a month. If I plot the data with a line chart, I get a series of lines that cycles through six different colors (see an ...