Questions tagged [charts]

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

Filter by
Sorted by
Tagged with
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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: ...
user avatar
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 ...
user avatar
  • 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. ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ",&...
user avatar
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 | ...
user avatar
  • 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 ...
user avatar
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, ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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-...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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,...
user avatar
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 ...
user avatar
  • 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, ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 – ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 160

1
2 3 4 5
30