# Questions tagged [charts]

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

1,391
questions

**1**

vote

**2**answers

24 views

### Creating Bar Chart with Start time and End time

I want to create a bar chart from the following data which will look like the attached picture. The data will have a start time, end time, and a number value.
Sample Data:
Bar Graph:
Basically, I ...

**1**

vote

**1**answer

35 views

### Comparing several years in excel line chart/diagramm

I want to compare several data values of several years over the course of a year. Something like this. For that, I changed all the data to be within the same year and I can put them in a graph ...

**1**

vote

**0**answers

33 views

### Excel graph recalculating values

I have this table of water consumption values, with twelve Jan-Dec columns, each flat has one line. But the cells contain value from the meter, so it is not a consumption in the month, but rather ...

**0**

votes

**3**answers

47 views

### Creating “regular” chart and a pivot table on data with gaps

I have a lot of data in an excel file that I am trying to display in 2 charts:
Regular graph chart (all data)
Pivot table (averages)
The problem is that I have a lot of gaps in my data that i dont ...

**0**

votes

**2**answers

35 views

### Excel: How to graph a multiple line chart by date and country

I have the following dataset that I would like to graph in excel.Dataset
The data is from OurWorldInData.org if you need the full dataset. It has a country, date, and new cases columns. I would like ...

**0**

votes

**0**answers

14 views

### How to get a vertical bar chart with the sum of rows grouped by month

I have a spreadsheet with over 300 rows, and in each row I have a Created At column with this date format: 20/Apr/21 5:34PM.
I would like to have a vertical chart that is the sum of the rows for each ...

**0**

votes

**0**answers

22 views

### Excel chart to match pivot table

So I have 2 different data sources and want them in the same format. (A) is using a pivot table to summarize monthly averages from daily flow data, (B) is a table that already has the monthly average ...

**0**

votes

**0**answers

35 views

### Excel Chart “Save as Picture” making dates into numbers

I'm trying to save a picture of an excel chart (for use in distributions where it doesn't allow me to just copy and paste the chart). So I right click the chart I want to save, click "save as ...

**0**

votes

**1**answer

69 views

### Stacked Area Line Chart with Overlapping Values

I'm trying to create an attendance chart. Previously, there was only 1 time slot, so I used a line chart. However, now there are 2 time slots. So, I'd like to do a stacked area line chart to summarize ...

**0**

votes

**1**answer

28 views

### Line graph of a single Cell that is dynamically changing

I have one cell in Excel that is simply the subtraction result of two other cells. The subtraction number is dynamic i.e. it is continually changing throughout the day based on the values of the two ...

**0**

votes

**1**answer

25 views

### I select columns A-D but Excel scatter graph only shows column D

I want x axis to be column A which is date & time.
I want columns B, C, and D values each to be different color on y axis.
Here are my steps...
open excel
Data > From Text
Select columns A-D
...

**0**

votes

**1**answer

41 views

### Combining identical horizontal data points on a clustered bar graph

How would I go about clustering horizontal values that are the same. I.E. how would I go about making "Review" one cluster with two bars side-by-side? As can be seen in the provided screen ...

**0**

votes

**1**answer

44 views

### What is the quickest way to create a scatter plot per row in a table?

I have a table with a list of customer spending per month. I want to create a scatter chart for each customer (row) to show the trend over time.
Currently I can only see that I can do it one-by-one. ...

**0**

votes

**2**answers

49 views

### Chart based on dates

I created a dashboard for my work program tracking. I am trying to create a chart based on the dates so I can easily see how many people have done their competency. I have conditional formatting for ...

**1**

vote

**0**answers

33 views

### How to make a grouped stacked chart in Excel? (see picture)

How do I make a chart like the one below here?

**0**

votes

**1**answer

25 views

### Removing individual datapoints from a scatter plot

I'm trying to remove anomalous data points in an excel scatter plot.
I currently have this. To me it's clear that there's a somewhat linear relationship in the red region, and several anomalous points ...

**0**

votes

**0**answers

36 views

### How do I add a second Y axis to an Excel area graph without misalignment?

I'm trying to plot two sets of data on an area graph centered around 0.
Currently it looks like this:
and I'd obviously like to add a second axis so that the orange data looks larger, and I have been ...

**0**

votes

**1**answer

32 views

### How to have two different units on an axis in microsoft excel?

I am trying to create a graph that has my company's cash position all time, but go by month from the beginning up until the end of 2020. Then starting in 2021 I want it go be graphed by every day, ...

**0**

votes

**0**answers

25 views

### Create 3D Clustered Column Chart

Is it possible to create a 'real' 3D clustered column chart in Excel?
I want to create what excel calls the '3-D Column', but I want each column to be a cluster of three columns instead of just one ...

**0**

votes

**1**answer

30 views

### Create multicategory timeline chart in Excel

I'd like to create an Excel chart showing on the x axis the dates from 1943 to 2021 and on the y axis the relevant category which follows a specific timeframe.
I.e. from 1/1/1943 to 18/01/1943 ...

**0**

votes

**0**answers

29 views

### Excel scatter chart: go from marker to data point cell

I need to be able to go from marker on a scatter chart to the cell of the data point of this marker. Is there any way to do that?
I see I can get to display data point values in a tooltip if I hover ...

**1**

vote

**1**answer

30 views

### Excel bar graph with error bar

At this point I feel kind of stupid for asking, because I should probably be able to do this.
I want to create a graph like seen on the first image below, with each task having its own label on the x-...

**0**

votes

**1**answer

26 views

### How do I convert this into a pie chart in Excel?

I have some data:
How do I for example display a bar chart or pie chart of the workbook-languages are listed?
43 is once
6 is twice
3 is once
etc. The actual descriptions for these numbers (the ...

**0**

votes

**0**answers

22 views

### Need graph series to not explicitly reference sheet name

I have an application that creates multiple worksheets with different data (but the exact same sets of datapoints).
I want a chart on each page where the series data refers to the data on that ...

**0**

votes

**0**answers

26 views

### geom_point plot continuous values by color or fill, while plotting another measure on the y axis

Reproducible data:
df <- data.frame(subject = sort(rep(c(1:85), 8)),
number = rep(c(rep(c("singular"),4),rep(c("plural"),4)),85),
modifier = ...

**0**

votes

**0**answers

12 views

### Plotting country outlines in Excel map charts

I've plotted a map chart in Excel of UK counties that looks like this:
What I want is to be able to have an outline of the whole of the country, instead of lots of whitespace for where there is no ...

**0**

votes

**0**answers

39 views

### Create a “dashboard” by using a “dynamic sumif”

Using the file at the below link, I have created a basic staff planner and Gantt chart. What I am trying to do now, is extract the data from the Gantt chart to produce a dashboard type thing to show ...

**0**

votes

**1**answer

69 views

### How do I add vertical errors bars (vertical lines) to a chart in Excel? The “vertical error bar” option is missing

I created a simple line chart in Excel 365, and I'm trying to add a vertical line to the chart at a specified date. I created the chart as a combo line chart (for the data) and a scatter plot with a ...

**0**

votes

**2**answers

43 views

### Excel charts, moving horizontal axis

I'm asking for help with an Excel charting problem concerning the horizontal axis. In this example, you can see that I've set labels to "Low," so they appear along the bottom. But the ...

**0**

votes

**1**answer

20 views

### How do you fill in the area under a data series in a line chart in LibreOffice Calc?

There is a line chart in an Excel spreadsheet that I'm trying to replicate in a native ODS spreadsheet. The chart has lines from multiple data series, and one of those lines has the area underneath it ...

**0**

votes

**1**answer

17 views

### How to create a Line Chart with a scaled X Axis and Dummy Variables

I'm intending on creating a line chart with three Lines. The Final X axis will display the Values shown in column Time Period. But I am using the column Days as a dummy variable to get the axis spaced ...

**0**

votes

**1**answer

39 views

### Single series of data on an excel chart (line) is reversing its order

I am creating a simple line chart in excel, using 4 data series against date (in the form of YYYY).
Three of these series are financial, and displayed against the primary axis.
One is non-financial, ...

**0**

votes

**1**answer

61 views

### how to add percentages to a simple bar chart in excel. Data is a series of strings in cells, I want bar chart to show percentages rather than count

I have been trying for hours to find a solution to this, but have not been able to.
Let's say I have this simple column in excel (a series of strings):
Now, what I want is a simple bar chart out of ...

**0**

votes

**0**answers

37 views

### Change Excel Chart Colour by Font Colour

I have a dataset with a bunch of colours represented in hexadecimal triplet form, and I noticed that by putting it in excel, it gets detected as a colour, and changes accordingly, excellent, love that,...

**0**

votes

**0**answers

23 views

### Excel - Scatter

I'm using scatter with straight lines and markers. When I try to graph a function like ×>=10 (10,0), it only shows me a dot located on the x axis only. I use select data, and just enter x series as ...

**0**

votes

**0**answers

12 views

### Excel create graph based on two columns and group by column two

Hi i have been trying to create a graph in Excel and i am unable to create a graph in the format i need.
I would like to have a Y graph axis column label for each unique channelID, and the X axsis is ...

**0**

votes

**0**answers

25 views

### How to update a chart in Word dynamically with a form

I have a dynamic chart inside a word document.
I inserted an Excel workbook via the Insert -> Tables -> Excel (not sure about the exact english text) rather than just inserting a chart.
My ...

**0**

votes

**1**answer

12 views

### How to show first data in a series in a line chart?

I have a line chart with years and months.
In my newest line (2021) I have just 1 column of data in the series. In this case Excel doesn't show anything.
jan
feb
mar
2019
5
5
6
2020
7
8
9
2021
9
...

**0**

votes

**1**answer

37 views

### How to create a scatter excel graph with y-axis above and above and below x-axis

I am trying to create an excel scatter plot/line graph that shows y-axis values above and below the x-axis. I am trying to recreate the graph in the link below for the data I have.
I have tried ...

**0**

votes

**0**answers

23 views

### Microsoft office 2007 Excel graph

Graph
Hello everyone, I want to draw a graph using Excel office 2007 where multiple independent events are shown along a single timeline. All these variables have their own reference ranges. I want ...

**0**

votes

**1**answer

19 views

### Labels in X-axis based on primary Y-axis

I have an Excel scatter plot with two Y-axises (primary/secondary) and a common X-axis. Everything looks fine, except I want the labels in the X-axis to be based on the primary Y-axis. I want the ...

**0**

votes

**0**answers

34 views

### How do I use LibreOffice to create a Bitcoin paper thing?

I have LibreOffice installed. I've opened each individual application, but I can't figure out which one would be the best one to use for this.
I basically am trying to print out a standard-sized paper ...

**1**

vote

**0**answers

14 views

### How to show different type of legend below specific columns under X axis on stacked bar chart

I have drawn a stacked column chart in Google sheet. I want to put different legends below specific columns as secondary label under the x-axis; here is my spradesheet link: https://docs.google.com/...

**0**

votes

**0**answers

16 views

### Excel chart with many series: legend is completely unreadable

I have an Excel chart with about 10-20 series.
The series names are quite long.
And the legend of the chart is damn near unreadable, unless I make the chart huge. It's not that you can't read the ...

**0**

votes

**1**answer

44 views

### Irregular label on Excel chart

I have an Excel chart with months on its x-axis. The first date is December 2016 and the last date is November 2020. I need these two dates to be seen,
but I can't have all the labels being seen (it's ...

**1**

vote

**1**answer

14 views

### How do I plot a point on a line of best fit?

I have a line of best fit graph on excel, and I want to plot points on it with 3 new data entries that only have Y axis values - and I'll get X axis values from the line of best fit. How can I do this?...

**0**

votes

**0**answers

21 views

### creating a excel chart that groups months by quarter

I have a table that contains the last 12 months of sales data like this
+-------------+------------+-------------+
| December-19 | January-20 | February-20 | and so on
+-------------+------------+-----...

**1**

vote

**1**answer

51 views

### Variable number of decimal places in Excel Graph

My Y-axis in Excel on a log scale currently shows values from 0.0001 to 1000.0000. I wish to edit the number of decimal places so those below zero are decimals yet those above are whole numbers. So ...

**0**

votes

**0**answers

21 views

### How to repeat consecutive numbers (1234…12 1234…18) on the x-axis of an excel chart

I have conducted two independent experiments (Exp-A and Exp-B), measuring the same parameter (NO3) in both.
Exp-A took 12 days(days 0-12) consisting of 6 independent sequenced batches (2 days each).
...

**1**

vote

**1**answer

31 views

### How can I use Excel to make a chart with two x-axis at different scales?

How can I use Excel to produce charts like the images below? Is it possible?
I want to have two different x-axis scales with major tick marks every 10 values. The only data I would want to display ...