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 ...
- 355
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 ...
- 101
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 ...
- 103
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:
...
- 111
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 ...
- 11
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
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 ...
- 13
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 ...
- 103
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 ",&...
- 11
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 | ...
- 13
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 ...
- 29
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 ...
- 745
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 ...
- 113
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-...
- 896
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 ...
- 167
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,462
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 ...
- 170
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 ...
- 11
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 ...
- 11
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,...
- 121
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 ...
- 99
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, ...
- 111
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 ...
- 177
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 ...
- 21
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 ...
- 713
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 ...
- 11
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 ...
- 1
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
...
- 148
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 ...
- 83
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 ...
- 101
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 ...
- 1
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 ...
- 3
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 ...
- 11
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 ...
- 6,432
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 ...
- 11
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 ...
- 53
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 ...
- 53
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 ...
- 33
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 ...
- 23
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 ...
- 160