Questions tagged [charts]
Graphs, charts and other graphical methods for showing data and their relationships.
1,533
questions
1
vote
0
answers
21
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 ...
- 11
0
votes
1
answer
19
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. ...
- 2,205
0
votes
0
answers
18
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 ...
1
vote
0
answers
23
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 ...
- 63
0
votes
0
answers
13
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.
2
votes
1
answer
79
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 ...
- 23
0
votes
0
answers
30
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 ...
- 103
0
votes
0
answers
27
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 ...
- 111
0
votes
0
answers
66
views
How to create a sparkline / single-cell chart that shows status color changes over time
I'm re-creating some reports that track the status of various projects over their lifecycle. Internally, we define the status of each project as Red, Amber (Yellow) or Green, and then these values are ...
- 113
0
votes
0
answers
25
views
Merging data in an axis
I haven't done much graph stuff on excel. Now, I have a job that will require graphs from time to time. I figured out how to make the graph. Now, I want to combine data from one axis.
I have ...
- 1
1
vote
0
answers
46
views
Is there a way to show horizontal and vertical gridlines on a Surface Contour chart?
I am creating a chart of type xlSurfaceTopView in VBA. I want the chart to have horizontal and vertical gridlines, but the last two lines of the following With statement only cause two gridlines to ...
- 11
1
vote
1
answer
17
views
Transforming category based data into column for time series chart
I've got data that looks like this -
task type
date
end time
task A
2023-07-01
1:00 AM
task B
2023-07-01
9:00 AM
task A
2023-07-02
1:01 AM
task B
2023-07-02
9:05 AM
task A
2023-07-03
1:02 AM
...
- 13
2
votes
0
answers
54
views
Stacked Area Chart Excel, 3 Series Negative Problems
I am trying to create a chart similar to this original chart. I'm having troubles with the negative values. The red area falls negative when I chart it as a stacked chart.
It seems like it should be ...
0
votes
1
answer
31
views
Google Sheets - Making a chart where certain series do not have data for all X-axis values
I am making a chart for research in musicology which requires me to graph the duration and tempo of notes based on the score, i.e. musical values like a quarter note.
Using a recording of a string ...
0
votes
0
answers
26
views
How would I create a dynamical line graph chart with multiple line graphs?
I am trying to create a dynamical line graph chart with multiple line graphs on the chart.
For example, I want to be able to graph this data, where each PADD will be its own chart, and on each of ...
- 23
0
votes
1
answer
45
views
Excel bar chart does not display to correct y-axis value
I have a bar chart wherein I display one set of data as a clustered bar and another data set as a line. All is well except the actual bars do not extend so as to display the proper value on the y-...
- 3
1
vote
0
answers
31
views
How to add a chart that would display 2 values from single row as {X,Y}
In LibreOffice, I have a table like this
Element,X,Y
name1,0,5
name2,1,2
name3,5,7
...
so, I would like a chart that displays dots at {0,5}, {1,2}, {5,7}
as I am trying to use Scatter (XY), all the ...
- 161
1
vote
1
answer
35
views
In Excel, can I make a data table have different data to the chart?
I am trying to add a table to a chart in MS Excel. I have looked at other answers, and they all seem to not quite do what I want to do, which is why I am posting here.
My data looks like this:
I wish ...
1
vote
0
answers
23
views
Libreoffice base design of Time-Table for College [closed]
I am supposed to work on THE Time-Table of my college which people have been doing manually so far. A college time-table is a mapping of a faculty to the class, day of the week, period of the day and ...
- 11
1
vote
1
answer
26
views
Linear Trendline does show up wrong in x,y chart in Excel
I have a simple set of GPS data for posts of a solar farm and want to add a trendline in a x,y chart to visualize the tolerance to the alignment of said posts. It works with the height of the posts ...
1
vote
0
answers
31
views
Excel Line Graph From Two Tables
I am trying to make a line graph with information from two different tables and my second line (orange color) is plotting on the wrong dates. The purpose of this graph is to show fluctuation in demand ...
- 13
1
vote
0
answers
32
views
Is this an Excel bug? Chart with large number of rows and columns includes data values as part of chart legend
In summary
I have a line chart with 25 series. If I chart the first 100 rows of data, all is well. If I chart 200 rows of data, the legend labels start including data values.
Details
In the ...
1
vote
1
answer
43
views
How to make sibling axis categories of a pivot chart independent of each other?
I have the following Pivot Chart. What I want to accomplish is to make each Main column feel like its own section. I tried adding horizontal (or vertical, it appears like Excel uses them ...
- 125
0
votes
0
answers
33
views
How to create a line chart showing change over time in MS Excel?
I have snapshots of datasets and I want to create a line chart showing the change.
For instance, each snapshot looks something like this (with different values):
I wish to create a line chart showing ...
- 1
0
votes
1
answer
165
views
Excel - Stacked Columns Compare Per Month and Year
I would like to show the following data
Year
Month
Client Type A
Client Type B
2023
Jan
44
45
2023
Feb
35
24
2023
Mar
48
45
2023
Apr
28
25
2023
May
0
0
2022
Jan
30
27
2022
Feb
34
47
2022
Mar
...
- 103
0
votes
0
answers
36
views
How do you omit a row from a chart so it doesn't appear in the excel graph
I have a chart of information
which has 3 rows against each month of the year: Actual Sales, Baseline Sales and the different between the Actual & Baseline (so the third row is a sum).
I want to ...
- 1
1
vote
1
answer
100
views
excel plot with Y non numerical values
I'm trying to make a "scatter straight lines and markers" plot with non numerical value for Y axis.
I'm not able to use non numerical index as y value.
Here is how my data looks like:
What ...
- 13
0
votes
1
answer
56
views
How to use the same color for the same index of data in a column of Excel?
I have the following Excel table, and now I need to draw a column chart.
The default column chart in Excel is as follows, how can I mark the same index with the same color?
For example, all bop ...
- 103
1
vote
1
answer
61
views
Excel XY Scatter Chart with automatic line breaks
I have a series of time and number pairs that I am plotting with an Excel XY Scatter with Straight Lines chart. The time values increase by a variable amount, though typically between 30 seconds and 2 ...
- 13
1
vote
1
answer
280
views
Scatterpoints not aligned with labels in a forest plot
I am trying to create a forest plot in Excel, following this website, How to Make a Forest Plot in Excel (2 Suitable Examples). I am having some issues: The scatter dots are not aligned with the ...
- 13
0
votes
1
answer
474
views
Chart axis labels — Use $1M (million) short form instead of full $1,000,000 number
I have a PivotChart in Excel 2016 that has dollar amounts as the x-axis.
Currently, the labels are formatted as full numbers. Example: $1,000,000.
Is there a way to format the labels by replacing the ...
- 137
0
votes
1
answer
284
views
Excel combo chart changing cluster columns into stacked
I am trying to create a combo chart with cluster columns and a line with a 7-day rolling average. One of the clustered columns is in percentages, the other is in whole numbers.
Here is the data set:...
- 3
1
vote
1
answer
25
views
can I identify multiple series (lines) with values embedded in excel rows?
This seems simple but I haven't been able to crack it yet. I have a timeseries data set that looks something like:
Time Val_1 Val_2
1.4 1 56
2.01 2 34
2.1 2 29
3.05 1 ...
- 340
0
votes
0
answers
23
views
How to make a chart that auto updates with daily changes based on rolling average without discarding older data
I have a spreadsheet that pulls the most recent 3 days of data from an xml feed and averages that data. Wondering if there is a way to build a chart that will graph those daily averages as they are ...
0
votes
0
answers
53
views
In an Excel pie chart, how to represent one value on a pre-set range of value
I an Excel 2021 spreadsheet, I have a serie of values between 1 and 9 in one of many columns of a table.
With a pivot table, I get the average of those numbers that I can then filter. But the issue ...
0
votes
1
answer
44
views
Produce a line graph plotting the three most recent values for a series
I'll start with the most immediate problem that I'd like to solve, and then below that explain the XY problem in case that helps, or in case I've gone about solving it in a silly way.
I have a table ...
- 648
0
votes
1
answer
20
views
How to connect the color of a legend in a horizontal chart for two groups?
I am trying to display the results of the performance of a set of rooms based on their responses to a test.
My goal is that the results above or equal to 50% to be marked as achieved results and those ...
0
votes
1
answer
40
views
How can I plot two lines sharing data and a single y column?
So I have this VERY simple assignment from economy class, where we have to plot this offer/demand table:
QD
QO
PREU
10
120
100
20
60
80
30
30
60
40
15
40
50
0
20
And in the book, shows how &...
1
vote
0
answers
42
views
Aligning chart image to right and legend to left
I have a pie chart in my word (data comes from excel). I can not align the pie itself to the right side of the text because the margin box does not allow me:
I can just push it a little bit to right ...
- 135
1
vote
0
answers
213
views
Make Excel Chart filter always visible
Click in the chart area of an Excel chart and one of the buttons that appears in the top right is a filter (just below a paintbrush and a plus sign – see screenshot below). Clicking it opens a filter,...
- 1,481
0
votes
0
answers
16
views
Misallinged ticks in Excel chart with multilabel x-axis displaying weeks
I am using Excel for Microsoft 365.
I created a stacked bar chart, where the x-axis is time, and should display weeks and days. I also wanted to include a vertical grid for every week.
However when I ...
0
votes
1
answer
95
views
Issue with dynamic Excel combo charts - handling missing data series & labels
Good afternoon all the good people,
Let me share with you something I've been struggling with for a while. I'm using pivot tables to plot different data points next to each other on the combo charts, ...
- 101
1
vote
0
answers
18
views
Excel line plotted graph changes when horizontal axis is changed to Date
I have always experienced a frustrating problem when plotting line graphs. The plotted lines are smooth as they should be, but I would still need to tweak the horizontal axis to Date in order to show ...
- 11
0
votes
1
answer
80
views
Scatter graph with desired series name
I have the above table, but however I try I cannot get the evidence gap to appear as individual series.
In this example there should be a total of 4 points with the legend of the points being Test, ...
- 1
0
votes
1
answer
1k
views
Removing outer white space around a bar graph
It might be a bit of a simple question but on
I want to remove the outer white space around the graph but I have no idea if its possible or how to do this. Any help woule be appreciated.
- 1
0
votes
0
answers
36
views
How to present a large dataset consisting of species population count over a 40 year period in a readable graph format
I created a pivot table and chart, detailing the different species and their population over a 40-year period, this is split up into seasons for each year. I would like to know if there is a better ...
- 1
0
votes
0
answers
31
views
Trying to create a line graph with Excel
I am trying to create a line graph in excel where the x-axis is miles, y-axis is rate. I want the name to appear for each line. For example, in the attached data, Jerry will have his own line. Bob ...
- 23
0
votes
0
answers
16
views
Why does chart formula change when using dynamic formula in Name Manager?
When I am trying to create a dynamic chart, I use name manager to set the axis. The formulas in name manager will either be an offset function or an index function, an example would be:
=DATA!$B$14:...
- 33
3
votes
2
answers
179
views
Formatting an excel chart with 2 columns in the horizontal axis
I have data in excel where I want to show 4 to 5 values per month. The horizontal access I would like it to be very easy to read. So for the horizontal axis I would prefer to have a month and year and ...
- 89
2
votes
1
answer
550
views
Can I have a numeric x-axis with an Excel stacked area plot?
I have some data that I can scatter plot like this:
However, I want to make a stacked line plot (area plot) like this:
But when I change the chart type to a stacked area plot, then the x-axis ...
- 123