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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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