Questions tagged [charts]
Graphs, charts and other graphical methods for showing data and their relationships.
1,391
questions
1
vote
2answers
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
1answer
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
0answers
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
3answers
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
2answers
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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 ...
