# Questions tagged [charts]

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

**0**

votes

**1**answer

15 views

### Returning row and column value in a large chart if column is in a range

This is for a wastewater oxygen saturation chart used in determining Biochemical Oxygen Demand values.
I want to find the intersection value returned to a cell of my choosing. But the catch is that ...

**-2**

votes

**0**answers

5 views

### Google Sheet Line Chart where series are in rows [migrated]

I have a Google Sheet with data in the following format:
| Timestamp | Sensor | Value |
|------------------|--------|-------|
| 2018-11-14 0:00 | A | 100 |
| 2018-11-14 0:01 | A |...

**1**

vote

**1**answer

25 views

### Excel 2016 Chart showing random dates in x axis

I'm simply trying to graph some time-scale data using a date column and 3 data columns, but Excel keeps screwing up the dates in the chart... (showing dates from year 1900-1903 instead of 2018)
All ...

**1**

vote

**0**answers

41 views

### Filter charts on a dashboard to display charts that are on other worksheets in the same workbook [on hold]

How to Filter charts on a dashboard to display charts that are on other worksheets in the same workbook?
So I know you can create the charts behind each other and move them forwards and backwards.
...

**1**

vote

**1**answer

17 views

### How to do an Arrhenius plot AKA How to do a reciporcal secondary axis in Excel 2010?

An Arrhenius plot show the logarithm of a property that is thermally acitavted versus the reciprocal temperature aka 1/T. Now is 1/T something that most people are not used to. This is why most of the ...

**0**

votes

**0**answers

27 views

### Number of points per square in a grid

I have a scatter plot as the example below, and I was wondering whether there is a way to summarize all the points in a square of the grid with the number of points in each square? For example, the ...

**0**

votes

**1**answer

48 views

### How do I create a self-updating line graph when new information is input every week in Excel table without including the total?

I have a line graph with the performance of two employees.
How do I get Excel to automatically show only the last five weeks’ numbers without me having to select the data manually and without the "...

**0**

votes

**0**answers

17 views

### Generating a line chart with data over a 10 days but displaying by hours rather than by days

I'm trying to generate a chart in Excel. My problem is, that the chart is being generated by days and not by hours. This is why on the 12th October there's only "a spike" visible and not an actual ...

**0**

votes

**0**answers

17 views

### How do I make Pie Chart Slices pop up in Microsoft Powerpoint?

I got assigned to make a 3-D pie chart in Microsoft Powerpoint
(in Office 365 Pro Plus).
I've already made the pie chart,
made sure there are no percentages showing (just the topics).
Now I need to ...

**2**

votes

**0**answers

16 views

### Format chart colours based on series values

Is it possible to format the colours of a bar chart with a single series based on their values, i.e. anything over 50 would be green, anything below would be red?
What I currently have to do is a ...

**1**

vote

**0**answers

25 views

### Excel 2016 waterfall chart losing data and formatting

I have a problem with a report I built and released into the wild.
It contains a waterfall chart with an offset within it linked to a spinner button to change the displayed data range on the fly. ...

**0**

votes

**0**answers

19 views

### Data Doesn't Appears On My Graph

I have many sheet with numerous formula, and I want to make graph with Formula results.
There are hundreds of cells and I don't want to change formula which are formatted as percentage, unless is not ...

**1**

vote

**2**answers

60 views

### How to set exact chart area size in excel 2016?

I know how to set the size of the diagram, but I cannot find the option for setting the size of the chart area (not sure if this is the correct name in English). The box I want to change is marked ...

**0**

votes

**2**answers

46 views

### How do I ignore Empty Cells in the legend of a Chart or Graph

I am having trouble with a combination graph in excel specifically with the x axis. I have two columns both go to 1000 but currently only have 13 entries the rest will fill in over time.
I have a ...

**0**

votes

**0**answers

44 views

### Flip the legend horizontally in Microsoft excel chart

I am using Microsoft excel with Arabic language, I would like to flip the legend horizontally, the color on the left and label on the right (figure).