Questions tagged [charts]
Graphs, charts and other graphical methods for showing data and their relationships.
1,321
questions
0
votes
0answers
10 views
Google Sheets value on chart off from source by very small fraction [migrated]
Trying to figure out why Google Sheets chart is off from the source data by a small fraction. My sheet has 7 rows of data and a sum row. All data only has 2 decimal points and the sum obviously has 2 ...
1
vote
2answers
18 views
Excel Mac - create graphs with two columns with values for x- and y-axis
In my Excel-file, I have four columns with information that I want to graph:
Sample data
I want to graph this information as follows: the values of t, time, should be the x-axis and the values for A,...
0
votes
1answer
23 views
Rows to a Pie chart or a table
Sorry if a similar question is posted earlier.
I have a survey output which has rows like shown below
Agree
Disagree
Strongly Agree
Agree
5.Agree
Disagree
7 . Not Applicable
Agree
...
..
...
I ...
0
votes
1answer
30 views
How to preserve an Excel chart when table filtering changes?
I have a fairly large table in Excel. I take several filtering steps, then make a chart from the filtered data. I have several more charts to create, so I un-filter the data to make a new chart. ...
0
votes
0answers
21 views
Dynamic Scatter Plot From Multiple Ranges Trouble
I have made a line chart where I can plot data in between four ranges that I can change using name managaer and the INDIRECT() function. When I try to do the same thing with a scatter plot, I get an ...
0
votes
0answers
28 views
Gantt chart with multiple start dates
I am fairly new to excel.
I have created a form of the Gantt chart. The problem that I am having is that my tasks are only one day but they happen multiple times during the experiment. The way that ...
0
votes
0answers
31 views
Excel Bar chart hide #N/A rows without VBA
In Excel, I have two columns:
When I plot a bar chart, I get the following:
How can I hide the #N/A values?
The #N/A are generated using NA()
I've created a Name in Name Manager for column T:
=...
0
votes
1answer
31 views
How do you add x-axis text labels to a 2-D Clustered Bar Chart
Graph I'm Trying to Build
I am trying to create a a 2-d clustered bar graph in excel similar to this image - image in link above. I can't add the text I need for the x axis values.
I've tried ...
1
vote
2answers
39 views
How to create a combo chart in Excel with 4 data series?
I have created this chart in Excel, but want to add another line to the secondary axis - I cannot see a way of doing this in Create Custom Combo Chart which seems to accept a maximum of 3 data series, ...
0
votes
1answer
35 views
Excel 2016 Chart > Date and Text on the same Axis
I received an interesting question yesterday during at work. Is it possible to have Date and Text values on the same Axis in Excel Chart, but that this "text" is actually formatted or somehow ...
0
votes
1answer
20 views
Statistic chart in Excel: why there is one bin for the “Overflow”?
I have this "Statistic Chart" plotted in Excel, in which I set 25 as the "Overflow bin". But why there is a designated bin at 25 (highlighted in red square)? How to remove this? I just want to show ...
0
votes
1answer
33 views
Breaking /unbreaking line in a graph in Excel
I have to work with an excel graph (this was already handed to me).
As you can see above the graph has a break between 2018 and 2019. I don't know how that was made. I now need to remove the break ...
0
votes
0answers
15 views
LibreOffice Calc arbitrarily crops first and last two data points
I'm currently using LibreOffice 6.1.5.2 for Linux. When creating a chart from a simple XY dataset, the program just arbitrarily chops away the first and last few datapoints. I would like to restore ...
0
votes
0answers
26 views
Excel Chart Horizonal Axis Bound issue
I have already created line chart from my old team mate, Chart has 12 months on data for various products price. Months are horizontal axis. (Jan-19, Feb-19.....,Dec-19).
Horizotal axis is has axis ...
0
votes
1answer
22 views
How to show percentage from a text row
I have my company core values like for example hardwork, ambitious, trust and courage. Daily i have to transcript the core value i have lived in excel sheet and prepare a percentage/pie chart for ...
0
votes
1answer
40 views
Microsoft Excel - Creating several separate graphs at once
Excel 2016. Suppose I have one column with about 1000 values corresponding to a horizontal axis, while I have 25 separate columns for vertical axes. I am looking for a way to automatically create 25 ...
0
votes
0answers
12 views
Change the individual settings of the concentric rings in a radar chart in PowerPoint 2019
I'm creating a radar chart in PowerPoint 2019. I can add radial axis and change their settings globally, and do the same for the concentric rings. But is it possible to change the settings of each ...
0
votes
1answer
51 views
no update excels chart while holding slider
I put some chart and slider in my excel sheet. As I draging slider then data in my sheet is chaning however my chart update only when I release my slider. I need to update my chart live even as I use ...
0
votes
1answer
52 views
Format series of excel pivot chart based on series title
I have a non-stacked pivot bar chart that is showing two values (Sum of Planned Hours & Sum of Actual Hours) for a number of Series.
What I want to achieve is a formatting rule that if all the ...
0
votes
1answer
26 views
Excel Chart Colour
Sometimes in Excel I create a chart, set the column/line/background colours to specific colours/gradients. Then some time passes and I go back to the chart and although the colours are showing correct ...
1
vote
1answer
79 views
Unable to Edit Chart Data in Powerpoint 2010 64 bit
when I create a powerpoint presentation and add a chart, I can edit the data in the excel window that opens initially. However once I close that excel window, I am unable to bring it back up if i want ...
0
votes
2answers
49 views
How to make a 2D column chart with a count value that appears multiple times?
I have an excel spreadsheet that looks like this:
https://imgur.com/a/wRPvrpj
I would like to plot a 2D column chart that has the temperature (middle column) on the horizontal axis and their count (...
1
vote
1answer
27 views
Non linear chart Y-axis EXCEL
Is it possible to create a chart in Excel in which the Y-axis goes up by order of magnitude rather than linear.
so rising like
1,10,100,1000....
Or even doubling
1,2,4,8,16,32.....
Rather than
...
0
votes
0answers
45 views
Create a pie chart for different items with filter
I need to create a pie chart for sold and not sold for 4 items. Items (pen, pencil, book, box) should be in filter. If I click any item my chart should show sold and not sold number.
data.csv:
Item,...
0
votes
1answer
24 views
I have pictures of 2 graphs and I need to extract the curves, change colors and paste both on a same graph in order to compare them
so basically the title.
Here's the graphs, so basically I need to compare both charts. I'd like to take the curve on one chart, change its color and paste it over the second one like on this chart ...
1
vote
1answer
142 views
HOW CAN I PLOT 3D (XYZ) GRAPH IN EXCEL
I have a table of data, however, it is in 2D (XY):
X 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Y 4 4 4 4 10 15 20 25 25 25 25 25 25 20 15 10 4 4 4 4
And the graph obtained will look like ...
0
votes
1answer
31 views
Excel Bubble chart risk map with labels - please help not working in 2016
Hi I am attempting to make a similar bubble chart (or ANY chart) to what was posted here:
Can this 5-attribute 2D risk map be built in excel?
Problem is, it doesn't seem to work in Excel 2016. Seems ...
0
votes
0answers
12 views
Shade part of chart in Libre Calc
I have recently switched over to using open source software. For a school assignment I am suppose to create a bell curve and shade part of it. I have already create a graph showing the bell curve, but ...
1
vote
1answer
33 views
Data Formatting in Excel
In the above graph you can see the data automatically starts from 0 but it doesn't make sense for the limit to start from 0 so i wanted to format my data such that excel doesn't extrapolate the data.
...
0
votes
1answer
84 views
Excel Chart data table. Formatting one row (TOTAL) only
Im trying to build a chart and Highlight TOTAL row in data table (that one underlined on screen) ;).
I can format only whole chart data table or nothing.
By a trick I did a "hidden" (no colour and ...
0
votes
1answer
86 views
Specific x-axis gaps or bounds
I need help with this specific situation. I have a table with values between 0 - 115 and i want to display them with a chart like in the picture below.
Picture1
The thing is that on chart i want the ...
1
vote
2answers
73 views
Excel offers different options for markers in different runs - why?
When I look at the built-in marker options in Excel, on of my running sessions offers cross as an option, another one does not.
What could be causing this and how to fix this easily?
Using Excel 2016....
1
vote
1answer
27 views
How to fit a polynomial trendline such that only the leading two coefficients are non-zero in Excel?
I have data on the displacement of an object over time and a cubic trendline fits it very well.
I know that the initial displacement is 0 so I can tick the "set intercept" box.
However, I also know ...
0
votes
2answers
28 views
Secondary horizontal axis in MS Excel scatter plot
Is there a way to introduce a secondary horizontal axis into an MS Excel scatter plot chart? I'm using Office 2013 on a Windows desktop.
More specifically, I have a series of outputs Y. Each "Y" ...
1
vote
0answers
36 views
Sunburst chart - displaying percentages of percentages
I want to make a sunburst chart in excel, where the inner doughnut adds up to 100%, and the outer doughnut displays the percentages of a sub category.
I have four main categories, A=30%, B=25%, C=20%,...
0
votes
1answer
22 views
Can a one-line bar chart be created with Excel 2010?
The goal is to create a simple one-line chart with markers at the proportional position of the values. As in the linked image example that follows with the values 0, 15, 35, 55, 82, 100, the chart ...
0
votes
0answers
18 views
How do i construct an aggregated/averaged trendline for these different data sets (Excel)
X Axis - Days
Y Axis - Price
I need to present an averaged trendline using the multiple sets of graphs described below -
Graph 1 - For checkin date = 01-10-2016 the graph between Check in date- ...
2
votes
1answer
33 views
Remove Line in Pivot Chart for Blanks
How do I get the forecast to not show the flat line in the past and also the actual to now show the flat line in the future?
1
vote
0answers
18 views
Plotting 2 dynamically-sized series on ONE line with Excel
My problem is: with excel, I want to plot 2 series on one line, where the first series has a changing size.
Here is an example to better understand it:
List_1: can be [0,1,2,3,4,0] or [0,1,2,...,15,...
0
votes
0answers
15 views
Select All Charts in Excel Workbook?
I have a workbook that has 25 tabs with each worksheet containing about 2-5 graphs. What is the best way select all the graphs in the different tabs at once?
I've tried selecting all of them via F5 ...
0
votes
2answers
73 views
Showing correct legend in a bar chart in Word
I have a Word document with a bar chart where I would like to show the legend. When I have multiple legends it's working fine but when I only have one legend the title from the bar is shown.
In the ...
0
votes
0answers
49 views
How do I create a graph from two groups of data without selecting data row by row?
Say you have this data:
First group of data:
A B C D E
a 0 1 3 4 5
b 6 7 8 9 5
c 0 1 2 3 4
Second group of data:
A B C D E
a 1 1 5 4 5
b 6 8 8 5 5
...
0
votes
1answer
49 views
How to make a graph in excel with 2 side by side x axis and one y axis
My question is how to figure a graph with 2 x-axis side by side with one y-axis. For clarification, i mean 2 x axis with minimum value (zero) at the middle and for example maximum value 15 at right ...
1
vote
0answers
72 views
How to save high resolution charts .png in Excel for Mac?
Is there any way to save a chart from excel to a high resolution png-file on office for Mac? I have tried to copy them into Word as well as saving them as a html-file, but the quality becomes really ...
0
votes
0answers
32 views
Giving plotted lines from a graph in excel a value to read new value
Given the graph attached in this post:
Dark blue plotted line -> r=0
orange plotted line -> r=1
gray plotted line -> r=2
yellow plotted line -> r=3
light blue plotted line -> r=4
I ...
0
votes
1answer
39 views
“Save a custom chart as a template” button / shortcut / quick access bar
In the OFFICE newer versions (+2010), the button Save as Template in the Design tab/Type group vanishes. I know it can be reached by right-clicking the chart, and cliking Save as Template. But I would ...
2
votes
0answers
25 views
Create a “clock plot” in Excel
I'm not sure exactly what this kind of chart is called, but I'm going to call it a "clock plot"
Basically I want to use it to visualize events that happen at certain times of day over say the course ...
0
votes
1answer
18 views
Color excel plot by field
I have data which looks like this:
Type, X, Y
Foo, 1.2, 3.4
Foo, 3.2, 8.5
Bar, 2.3, 8.4
Baz, 3.4, 5.3
I would like to make a scatter plot of the x and y columns, and color the dots by the type ...
1
vote
1answer
30 views
Using Excel to plot a chart of change in ranking for two distinct groups
I'm having a fight with Excel charts. Here's my scenario:
I have three columns of data: Ranking1, Ranking2 and Exp? which are a number, a number and a boolean respectively. I want to create a line ...
1
vote
1answer
34 views
Microsoft excel open high low close chart creation?
I have a bunch of raw data that is ordered in a column with the first cell being the open, and the last cell being the close. is there a set of formulas I can use where it can sort the open high low ...
