Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [charts]

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

0
votes
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
2answers
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
2answers
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
0answers
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).

15 30 50 per page