# Questions tagged [charts]

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

1,321
questions

**0**

votes

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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 ...