Questions tagged [charts]
Graphs, charts and other graphical methods for showing data and their relationships.
1,565
questions
5
votes
1
answer
339
views
MS Excel: Displaying custom lower error bars
I have an odd issue with custom error bars in MS Excel 2016 (from MS Office 365). The upper error bars are showing but not the lower ones. At least not all the time... only once in a while...
See the ...
5
votes
1
answer
2k
views
How to cancel tedious Excel charting operation without crash
I'm charting about 17,000 data points in Excel. Needless to say charting is slowwww.
I accidentally selected the wrong chart type (Bubble thing?) and it is loading forever. I did not save my last ...
4
votes
4
answers
66k
views
Is there a graph paper like drawing software?
I have a college assignment, where I have to draw diagrams of voronoi, delaunay, minimum spanning tree etc for the college. I want to do that in computer. I searched in google with no luck. Is there ...
4
votes
3
answers
142k
views
Plot multiple sets of x,y data on a single chart
Have several series of data I want to plot on the same chart:
Series A
X Y
4015188 7361762
4020374 9581526
4022289 10649655
4023878 11223132
4025512 12035416
4028600 13408580
4030353 ...
4
votes
2
answers
18k
views
How do I create a chart in Excel with dynamic series based on the data content?
How would I define a chart in Excel (2010) that shows a time series graph containing various series based on the data content itself? For example, here is a data set:
Date Series A Values
...
4
votes
3
answers
7k
views
Excel trendline accuracy
This is a problem I have every once in a while, and it annoys me tremendously, beacuse I have always to recheck every trendline I get.
An example:
r L
(mm)
30,00 97,0
60,00 103,2
...
4
votes
2
answers
149k
views
Finding Y with X on Excel scatter plot/trend line
If I have some data in an scatter plot in Excel, e.g.
X Y
1 10
2 20
3 30
4 40
5 50
and I want to find the Y value for X = 10, or X=3.5, or whatever (obviously this is a simplified example) I've been ...
4
votes
3
answers
82k
views
Manually adjust axis numbering on Excel chart
I want to adjust the X axis of my scatter diagram according to my diagram points in MS-Excel 2010. I have seen in some guides that I can change it by editing the "Axis Labels" in "Select Data". As you ...
4
votes
1
answer
28k
views
Advanced Chart in Excel - column width based on cell value
I am an intermediate excel user struggling to create a specific chart for an internship project. I have spent a lot of time trying to figure it out and have searched the web extensively.
Below is an ...
4
votes
2
answers
34k
views
Creating a graph that groups data by date and category
I'm looking at a CSV file from Twilio showing outbound text messages. I have three messaging services, each with a distinct phone number. Each row in the report represents a message, and has a ...
4
votes
2
answers
4k
views
Excel chart can't handle data gaps
Why is it that Excel can simply ignore data gaps and connect points with lines?
I have this table that plots as this graph. Whether the gaps are in the table as empty (""), or "#N/A# or "#VALUE!", ...
4
votes
1
answer
34k
views
What are the labels for minor ticks in a log scale graph? [closed]
What are the labels for the minor ticks in a log scale graph?
I would like to label them. So, I want to know how to calculate the value for each of the minor tick.
4
votes
1
answer
86k
views
How to tell Excel to plot one column on x axis and another column on vertical axis?
I intend to plot y=cos(cX) in Excel, where c is a constant produced in first cell of column C using RANDBETWEEN(-50,50). Column 'A' represents X values (from -100 to 123) and column B contains f(x) ...
4
votes
5
answers
927
views
Good graph plotting app [closed]
Does anyone know of a free graph plotting app for Windows (or an online tool) that can plot something like this?
Xn+1= r sin (π * Xn)
4
votes
1
answer
40k
views
How to make a concentric pie chart in Excel?
I'd like to make a chart (preferably on its own sheet) that is a combination of a regular pie and a doughnut. The regular pie sits in the middle and the doughnut surrounds it.
I have seen those ...
4
votes
1
answer
25k
views
possible to have two Y axes and two X axes on same chart
Is it possible to have a chart with
left Y axis
right Y axis
top X axis
bottom X axis
all on same chart?
4
votes
1
answer
3k
views
How to make LibreOffice Calc to connect points in a holed series chart with lines?
I've got a time series data table with one function (row) value available for every month and the second for every 3rd month (every quarter), having holes (empty cell values) for every 2nd and 1st ...
4
votes
1
answer
2k
views
Why is my Excel chart grouping all my x-axis time values at 0:00?
I am using Excel 2016 for Mac to produce a time-based chart to record two temperature. One column for the date and time, two more for temperature readings. However, Excel appears to be ignoring the ...
4
votes
1
answer
17k
views
Changing the units on the x-axis in a LibreOffice Calc chart
I've used the LibreOffice chart wizard to make a chart, and I would like the x-values to be different to the default of 1,2,3... (in this case, 500,1000,...). How can I do this?
4
votes
1
answer
6k
views
Generate event distribution chart in Excel
I have a single column in Excel with lots of date/time stamps (in UTC) of certain events, like this:
2014-02-20 23:04:57.9263690 +00:00
2014-02-20 23:05:02.3117944 +00:00
2014-02-20 23:05:02.7490564 ...
4
votes
1
answer
4k
views
Create graph for requests per minute and uri
I have a table that looks like this.
time|uri
08:50:28|foo
08:51:42|bar
08:52:48|foo
08:53:49|bar
08:53:50|baz
08:54:02|bar
08:54:03|baz
08:55:27|foo
08:55:34|baz
08:56:47|bar
I would like to make a ...
4
votes
3
answers
13k
views
How to change Excel chart size with screen size
I have a Excel spreadsheet that is edited primarily from my desktop
computer at work (which has two large screens) but is also sometimes
edited on my personal laptop computer from home (which has one
...
4
votes
2
answers
13k
views
Get Excel to base tick marks on 0 instead of axis ends (with fixed maximum or minimum)
In other words, I want Excel to anchor the tick marks at 0.
I am trying to get an axis that goes from -35 to 35, but with the ticks on multiples of 10:
30, 20, 10, 0, -10, -20, -30
I have set set a ...
4
votes
2
answers
15k
views
Multiple Y-axis labels in Excel 2010 line chart
I have a table containing cycling data. Date, distance, time, calories burned, max heart rate and average heart rate. They all have different value ranges. Excel scales the chart to show the calories ...
4
votes
2
answers
2k
views
How can I split the wedges of a pie chart to show extra information per wedge in consecutive rings?
I'm plotting disk partitioning and available space.
I have a pie chart showing the partitioning: e.g. 30% /, 70% /home.
In the second ring I want to show that 90% / is full, 10% of / is empty. 10% /...
4
votes
4
answers
966
views
How make this graph in Excel?
I'm trying to do this kind of graph in Excel, but nothing so far.
I don't find anything like it, but it has to be this way, not bars.
starter 22,58 20,76 7,1 37,93 68,42
...
4
votes
3
answers
22k
views
Chart data by month
I've the following data in an excel spreadsheet:
Date (dd/mm/yyyy) Value
----------------- ---------
01/04/2011 123.45
03/04/2011 7234.25
16/05/2011 80.00
11/06/...
4
votes
3
answers
18k
views
Graphing mean and standard deviation
I have measurements for multiple devices, and have their mean and sd values. I would like to produce a chart that would show these values, and I think the best would be if I could have something that ...
4
votes
1
answer
29k
views
Excel - Plotting different y-values on top of same x-values
I'm trying to figure out a way to plot my data so that values in the same category are stacked on top of each other like this:
But whenever I go to plot it I end up with this:
I've been searching ...
4
votes
1
answer
11k
views
A chart where the line between points does not interpolate
I have an Excel spreadsheet showing the balance of a bank account over time. Each data-point is the balance of the account immediately after a transaction (so there might be several per day, with the ...
4
votes
1
answer
4k
views
Excel Error Bars From Pivot Table
When Excel generates Standard Error error bars, it takes into account the number of data points. If a chart was generated from a pivot table, does Excel use the number of points in the pivot table, 1, ...
4
votes
1
answer
135
views
Excel Chart type
I want to create kind of a hybrid chart, where some data is stacked in a bar graph, and then inside of a larger data set.
Basically I want the first three series "Adoptions" "Best Friends" and "New ...
4
votes
1
answer
3k
views
Automatically ignore empty rows for diagrams in LibreOffice Calc
The task I am trying to get done is the following (hope I am able to clarify what I mean):
LibreOffice 5.0.5.2
1024 rows of data in a Calc sheet
~256 lines with excerpts of the data right of the ...
4
votes
1
answer
6k
views
Excel - How to create a stacked radar chart?
I am trying to create a stacked radar chart in Excel similar to this:
.
I have to fill color in the space between the red and blue lines. I have tried every which way I can think of but to no ...
4
votes
2
answers
20k
views
Create a stacked bar chart that displays data in monthly intervals?
I have a table with dates and prices, and I want to create a bar chart, which shows me total amount spent in months. Table looks like this:
30.5.2014 700,80 CZK
6.6.2014 1 000,30 CZK
20.6.2014 ...
4
votes
2
answers
1k
views
Drawing sample points versus time in Excel
I have a set of data as follow:
As you can see the first column has either R or P, the second column is a measured value, and third one is obviously time.
I need to present this in a chart (I ...
4
votes
2
answers
15k
views
Excel: Pie Chart of a Question with Limited Possible Responses
I distributed a survey online and received the answers in an Excel spreadsheet. I would like to make a pie chart out of some of the closed option answers. For example, one of the questions was gender. ...
4
votes
4
answers
2k
views
MSFT Excel pivot table links to external data
Question1: What is the best online forum to ask MSFT Excel questions of the following variety?
Question2: How can I link an excel pivot-table to a potentially changing source table without having to ...
4
votes
2
answers
11k
views
How to create an Excel chart with no numerical labels?
I'm using Excel 2016 and I'm trying to create a graph that shows a list of skills against the skill level. I'm fine with the skill level being represented as a numeric value however I'd like the ...
4
votes
1
answer
6k
views
Zero values in Excel logarithmic chart: Can the warning be suppressed?
I'm plotting data in an Excel 2003 chart with a logarithmic scale on the Y axis. Some data points are occasionally missing, and this is represented by blank cells. The resulting graph looks like the ...
4
votes
3
answers
2k
views
Creating map of countries colored using country statistics
I want to create a PNG (or GIF) image, with geopolitical map of countries, where each country has color set according to some country statistics (e.g. 'USA' has n, 'Canada' has m, etc.).
Something ...
4
votes
3
answers
92k
views
How to rename the values on Y Axis in Excel?
I'm trying to rename the values that are on my Y Axis on a chart in excel. Currently I have mapped various letters to number equivilants just to get it plotted, but would like now to have the letter ...
4
votes
1
answer
912
views
Excel chart – massively create two point lines
I want to create a very custom grid for an Excel chart. I am trying to create a grid system like this:
It's called a tripartite graph. For the vertical and horizontal gridlines it's easy, I just ...
4
votes
1
answer
1k
views
Excel 2010 create pie chart with labels which apply to more than one segment
I want to create a pie chart with data labels which refer to more than one segment.
I have found an approximate way of doing this - these are the steps I followed.
My data looks like this:
I want ...
4
votes
1
answer
2k
views
Add multiple series to a dynamic chart
I have a large amount of data stored in a table that is used to update about 8 charts (through named ranges). Each chart has the date and ID as the x-axis with a particular parameter being charted. ...
4
votes
1
answer
14k
views
Add custom error bars to multiple series in one graph
I have my data in a csv file like below, except with more columns and rows
Mean values 61 43
Sample 1 0.009 0.059
Sample 2 0.108 0.099
Sample 3 0.043 0.038
...
4
votes
1
answer
16k
views
How do I create a PivotChart from a subset of PivotTable data?
As part of a dashboard, I've created a PivotChart from a PivotTable in Excel 2010, but the PivotTable includes extra columns that are cluttering up the chart. But when I adjust the values list on the ...
4
votes
1
answer
761
views
Line Graph using Row summations
I'm having some trouble in Excel producing a line graph for the following data:
+------+--------+-----------+-----------+
| Id | Type | Owner | Date |
+------+--------+-----------+-------...
4
votes
1
answer
1k
views
Create line graph with embedded horizontal histogram
How do I create these kinds of graphs:
with the horizontal histogram counting the number of times the left graphs go through a certain range?
I have access to Microsoft Excel and R.
4
votes
0
answers
2k
views
How to chart time of day in Google Spreadsheet with midnight crossover? [closed]
I'm struggling with the best way to chart a series of times in Google Spreadsheets that involves a midnight crossover. The data in question is a graph of a bedtime, when the time to bed is after ...