Questions tagged [charts]

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

Filter by
Sorted by
Tagged with
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 ...
user124752's user avatar
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. ...
Tobia's user avatar
  • 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 ...
Tod Stewart's user avatar
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 ...
Doom's user avatar
  • 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.
Thao Tran's user avatar
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 ...
Mohit Singh's user avatar
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 ...
whv20's user avatar
  • 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 ...
Wolff's user avatar
  • 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 ...
DTR's user avatar
  • 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 ...
Rikki's user avatar
  • 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 ...
jisner's user avatar
  • 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 ...
Karan Juneja's user avatar
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 ...
SilverSamwise's user avatar
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 ...
Santiago Garcia Cuevas's user avatar
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 ...
anon1212's user avatar
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-...
RTO's user avatar
  • 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 ...
62mkv's user avatar
  • 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 ...
Simon Joubert's user avatar
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 ...
Mukund's user avatar
  • 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 ...
Steven Fechner's user avatar
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 ...
Juan P.'s user avatar
  • 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 ...
youcantryreachingme's user avatar
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 ...
Paul's user avatar
  • 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 ...
Shruti's user avatar
  • 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 ...
Coenie Richards's user avatar
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 ...
Lucy's user avatar
  • 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 ...
Poncho89's user avatar
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 ...
Gerrie's user avatar
  • 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 ...
JonEd's user avatar
  • 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 ...
Ddddddd's user avatar
  • 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 ...
User1974's user avatar
  • 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:...
Khat 's user avatar
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 ...
ljwobker's user avatar
  • 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 ...
user1779545's user avatar
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 ...
Alexandre Rivara's user avatar
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 ...
Lou's user avatar
  • 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 ...
Chris Steinbeck Bell's user avatar
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 &...
Zenikonig's user avatar
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 ...
DEKKER's user avatar
  • 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,...
feetwet's user avatar
  • 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 ...
István Szabó's user avatar
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, ...
krakowi's user avatar
  • 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 ...
David Bugeja's user avatar
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, ...
Darren's user avatar
  • 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.
Avawahwa's user avatar
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 ...
pogus's user avatar
  • 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 ...
anon1212's user avatar
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:...
quant4u's user avatar
  • 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 ...
Shane S's user avatar
  • 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 ...
nicolejane33's user avatar

1
2 3 4 5
31