Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

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
23 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 ...
Paramvir Singh's user avatar
0 votes
1 answer
35 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 ...
nnaemeka_DS's user avatar
1 vote
1 answer
19 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 ...
lvbx9's user avatar
  • 11
0 votes
1 answer
52 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&...
Adrian McCarthy's user avatar
-1 votes
1 answer
103 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.
Fahad's user avatar
  • 1
1 vote
1 answer
43 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 ...
vks2910's user avatar
  • 25
1 vote
2 answers
76 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=...
Devin Baillie's user avatar
0 votes
0 answers
37 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 ...
Manfred Weis's user avatar
0 votes
1 answer
19 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 ...
Nick's user avatar
  • 5
0 votes
0 answers
26 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 ...
Britt Wescott's user avatar
1 vote
0 answers
14 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, ...
whburling's user avatar
1 vote
1 answer
87 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 ...
Bassie-c's user avatar
  • 129
0 votes
2 answers
59 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?
Finni's user avatar
  • 111
1 vote
1 answer
65 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; ...
patricktokeeffe's user avatar
1 vote
1 answer
116 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 ...
Shinobi Def's user avatar
0 votes
0 answers
29 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 ...
user619818's user avatar
1 vote
0 answers
29 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 ...
yusuf shikder's user avatar
0 votes
0 answers
35 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 ...
Cole's user avatar
  • 3
1 vote
1 answer
254 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 ...
superfrootbythesuperfoot's user avatar
1 vote
2 answers
235 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 ...
Antonio's user avatar
  • 113
2 votes
1 answer
476 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 ...
Madmenyo's user avatar
  • 890
0 votes
1 answer
70 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 ...
Benyamin's user avatar
  • 101
1 vote
1 answer
37 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 ...
hi-bye125's user avatar
  • 129
1 vote
2 answers
42 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 ...
Mister SirCode's user avatar
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
Justin's user avatar
  • 1
0 votes
1 answer
263 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 ...
S_Pochedly's user avatar
2 votes
1 answer
90 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 ...
David Walden's user avatar
2 votes
0 answers
84 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/...
d-b's user avatar
  • 814
0 votes
0 answers
42 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 ...
Robious's user avatar
0 votes
1 answer
59 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 ...
Ryan Thomas's user avatar
2 votes
2 answers
403 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 ...
Aidan C's user avatar
  • 21
0 votes
0 answers
52 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 ...
edson's user avatar
  • 1
0 votes
1 answer
417 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
infinitieunique's user avatar
0 votes
2 answers
544 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 ...
MyDaftQuestions's user avatar
0 votes
0 answers
76 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-...
tam's user avatar
  • 1
0 votes
1 answer
441 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 ...
Regus Pregus's user avatar
0 votes
0 answers
66 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 ...
user348514's user avatar
1 vote
1 answer
279 views

Can I set colors in an Excel bar chart tied to dynamic data?

I have a bar chart that is tied to some data that changes quarter to quarter. I have the data set up to sort automatically. I would like it so that, for example, the bar for City is is always purple ...
EsScott's user avatar
  • 11
1 vote
1 answer
269 views

How to create a chart that uses cell information like a pivot chart slicer

I have a page that has data aggregrates. The user will have to enter what brand it wants information calculated for. Then eventually, this will allow multiple charts to filter per this brand. That is ...
Paul's user avatar
  • 159
0 votes
1 answer
150 views

Which is the best graph to showcase 3 years of data grouped by weekly?

I want to present last 3 years of data grouped on a weekly basis. I have grouped the data in Excel on a weekly basis. I researched and found that a Box plot can be a good way of showing this kind of a ...
tunnelview's user avatar
0 votes
0 answers
77 views

PowerPoint Charts/Graphs - Images in Value Labels

I am working on a project to show information about sports teams. I would like to include their logos in the chart's column labels instead of having to only use the abbreviations to represent the team....
psycoperl's user avatar
2 votes
1 answer
973 views

Merge multiple 'lines' from a line chart into one line

I currently have a chart as follows: As you can see, I have three 'value' columns per X-axis item represented by the colours blue, orange and grey. I also have three 'count' lines represented by the ...
Monomeeth's user avatar
  • 1,289
1 vote
0 answers
104 views

Excel legend (bring to front)

I have an excel chart which has a blue gradient image bar at the top behind the title and subtitle. I want the legend to be in the top right but it automatically puts it underneath the blue bar and ...
user124752's user avatar
0 votes
1 answer
33 views

How to get a time edging chart with Excel?

Let's consider this example data: time value 09:30:00 a 09:50:00 b 10:00:00 c 15:00:00 d 15:20:00 e I would like to have a time edging graph counting the "value" column. ...
Tobia's user avatar
  • 2,291
0 votes
0 answers
46 views

Excel | SLA for Report that's due at 1am | Charting

We have a client report that has an SLA of 1am. The earliest the data is available to run the report is 11pm, so, we know that a report time between 1:01am and 10:59pm has missed the SLA). I have one ...
Tod Stewart's user avatar
1 vote
0 answers
115 views

Charts losing named ranges, replaced with _{r1}, _{r9}, etc. Am I doing it wrong?

I am using named ranges in a chart within which are OFFSET and INDEX/MATCH functions in order to drive dynamic chart behaviour based on changing the month in a cell. A couple of times today as I have ...
Doom's user avatar
  • 63
0 votes
0 answers
30 views

Gantt Chart Graph Color Modifications

How do i change the colors to the graphs in the Gantt charge? I have 2007 version and it is a little vintage, but the person at work wouldn't help me, but asked me to join a group to find out how to.
Thao Tran's user avatar
2 votes
1 answer
409 views

How to create a stacked column chart where each category has unrelated subcategories

I have the following set of data I want to create a column chart with 3 stacked columns(one for each category). The sum of amounts for each category equals 100. The issue I'm having is that the ...
Mohit Singh's user avatar
0 votes
0 answers
402 views

Even spacing between Excel legend entries

When entries in an Excel legend have different lengths (and the font size is such that they take up different numbers of lines), the spacing between the text of each legend entry is uneven: I realise ...
whv20's user avatar
  • 113
0 votes
0 answers
1k views

Is there a way to automatically set a chart's Y-axis bounds based on the max/min values of the X-axis, but only the range displayed?

So I have a chart that plots a value each day. The chart references the whole data range, but the X-axis is set via a macro to display usually only the last 3 months worth of data. This creates a ...
Wolff's user avatar
  • 111

1
2 3 4 5
32