# Questions tagged [charts]

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

1,490
questions

0
votes

1
answer

20
views

### Removing outer white space around a bar graph

It might be a bit of a simple question but on
I want to remove the outer white space around the graph but I have no idea if its possible or how to do this. Any help woule be appreciated.

0
votes

0
answers

14
views

### How to present a large dataset consisting of species population count over a 40 year period in a readable graph format

I created a pivot table and chart, detailing the different species and their population over a 40-year period, this is split up into seasons for each year. I would like to know if there is a better ...

0
votes

0
answers

30
views

### Trying to create a line graph with Excel

I am trying to create a line graph in excel where the x-axis is miles, y-axis is rate. I want the name to appear for each line. For example, in the attached data, Jerry will have his own line. Bob ...

0
votes

0
answers

11
views

### Why does chart formula change when using dynamic formula in Name Manager?

When I am trying to create a dynamic chart, I use name manager to set the axis. The formulas in name manager will either be an offset function or an index function, an example would be:
=DATA!$B$14:...

3
votes

2
answers

79
views

### Formatting an excel chart with 2 columns in the horizontal axis

I have data in excel where I want to show 4 to 5 values per month. The horizontal access I would like it to be very easy to read. So for the horizontal axis I would prefer to have a month and year and ...

0
votes

1
answer

28
views

### Can I have a numeric x-axis with an Excel stacked area plot?

I have some data that I can scatter plot like this:
However, I want to make a stacked line plot (area plot) like this:
But when I change the chart type to a stacked area plot, then the x-axis ...

1
vote

1
answer

25
views

### Create scatter plot using two arrays of data in Excel [duplicate]

I'm an aspiring eSports rookie who has been tracking his training progress for some time now. I have two tables in an Excel worksheet: The first is Accuracy, with rows being date and columns being ...

0
votes

1
answer

31
views

### How can I copy a larger number of cells into a smaller number of cells that are already feeding a graph?

I have two 10-cell columns that currently feed a graph (one for the x-axis, the other for the y-axis). I have now doubled the discretization of my dataset, so instead of the original 10 data points, I ...

0
votes

1
answer

26
views

### Combine two related line graphs

If I have this data
Product 1
Product 2
3.88%
5.71%
0.70%
4.58%
0.38%
4.64%
1.41%
1.62%
5.24%
1.32%
1.15%
6.47%
where the percentages (Y-axes values) are a certain metric of the prodcut and ...

0
votes

0
answers

12
views

### What is the fastest way to plot multiple plots with similar data on the same chart?

I am trying to plot some data in which I have several sets of data with the same x and y-data. I am trying to plot them all on the same chart. Once I have plotted the first pair of x-y data by ...

0
votes

1
answer

31
views

### Excel: Plot a single X and Y coordinate in a static graph

I am trying to create a coordinate graph where the X and Y axis are in a static 1 to 4 scale and the values do not change. The point to be plotted is gathered from two formulas that calculate the ...

0
votes

0
answers

33
views

### Displaying multiple lines for multiple years in line chart with Excel

I have a dataset in the following format that spans across multiple years:
Date No. People
01/01/18 7
01/02/18 0
01/03/18 2
...
01/01/22 63
01/02/22 18
01/03/22 ...

0
votes

1
answer

87
views

### Custom error bar for each datapoint Office 365 Excel

I have a dataset where each point has a different sized error bar. With Excel on Office 365, how can I customise the size of an error bar of an individual point? On the "Vertical Error Bar" ...

0
votes

1
answer

115
views

### Hide selected data series and data labels in chart

enter image description hereIn a Pivotchart, i have data labels with values starting from 0 and they also have name series. How do i show only data labels greater than 3? ( i don’t want my chart to ...

1
vote

1
answer

37
views

### How do I prevent Excel from only keeping the first data point of the series that I selected when using ctrl+shift+arrow?

When adding a series to a chart in Excel, I typically click the first value, then use ctrl+shift+down to select large amounts of data. I do this for both the x and y values. However, Excel only saves ...

0
votes

0
answers

51
views

### Create chart in excel that will compare different sessions on the same timeline

I have three devices that report battery percentage to my server every 15 minutes. The exact time that the devices report can vary. I took a sample of the three devices over a period of about 30 hours ...

2
votes

0
answers

25
views

### Is there a way to make 'edit' mode the default while editing series data in Excel charts?

When editing a series for a chart in Excel (2017), the default mode in the dialog boxes for series name, x values, and y values is 'enter' mode. When I use the arrow keys in the box it adds a cell to ...

0
votes

1
answer

38
views

### Format Y-Axis of a chart to 1M, 2M, 3M, etc

I would like to format the Y-Axis of a chart.
At the moment, the values on Y-Axis are 1000000, 2000000, 3000000, 4000000, 5000000.
What I would like to display is 1M, 2M, 3M, 4M, 5M.
I found the place ...

0
votes

0
answers

39
views

### Rotate radar chart in PowerPoint

I'm having a radar chart in PowerPoint with an uneven number of corners, e.g. like this:
I would like to rotate it by 180°, so that the tip is facing down, not up.
The usual rotating of elements is ...

0
votes

1
answer

199
views

### How to show a percentage of another value on a pie chart? Excel

I'm trying to make a pie chart based of two values: The total number of sales and number of special requests from those total sales.
So if I have 50 sales, but 5 were special requests, the pie chart ...

0
votes

0
answers

26
views

### Excel: Group 1700 entries by the year in which they each occurred in

I have a list of all crime that occurred in a neighborhood from 2014 to present day. Each incident-entry (it's own separate row) has a date value (making a date column), which I can format to just be ...

0
votes

1
answer

56
views

### Right to left chart legend in excel

I want to use excel for right-to-left language

0
votes

0
answers

43
views

### How do I create a one dimensional bar chart in excel where the lower and upper bounds are a part of the data set

I have this set of data values:
description
value
Last 7 Days
1.80
YTD
2.03
Upper
2.40
Lower
1.70
I'd like to create a one dimensional bar chart that reads the upper and lower values and uses ...

0
votes

1
answer

25
views

### Excel Chart: I want to select entire rows, however now the chart also uses empty cells after the end of my data (which messes everything up)

I have an excel sheet where I keep track of my daily self-improvement activites, sorted into different categories.
One row with the day's date, the rest of the rows activites with how many minutes I ...

1
vote

1
answer

35
views

### Why doesn't Excel show the data points and values on this geographic map chart of US counties within a state?

I have these (arbitrary) data points in Excel, and I've selected the Geography type for each of the counties in the US state of Massachusetts.
I inserted a map chart, which displays the following map:...

0
votes

0
answers

307
views

### Microsoft Excel - Why is my graph not plotting correctly?

I have two columns of data,
the first column is Average RT, going from 2050 to 20450.
My second column is fraction, from 0.000000 to various decimals, but all add up to 1.
My aim is to plot the ...

0
votes

0
answers

24
views

### Batch removal unwanted legend entries in Excel

I have a lot of series in my chart legend, but I just need just a few of them.
I bounded with black just these series which I need. The rest of them should be deleted.
I know how to delete the series,...

1
vote

0
answers

19
views

### How to filter rows for a pivot chart to ensure one to one relationship in results

I am trying to put together a PivotChart as such:
Each recipe is made up of ingredients. Each ingredient maps to (potentially) many products. Croissant Dough for instance calls for 40g of butter. ...

0
votes

2
answers

113
views

### Proportional Date axis in Excel

I have an Excel file with two variables. I'm using the x axis as a date variable. That column of data is formatted as a number->Date. But when I insert a graph of it, it treats the x axis as a ...

0
votes

1
answer

83
views

### Graph multi-day data on a time series

I have a table consisting of (timestamp, integer) where the timestamps comprise readings over multiple days. I want to use this data to plot multiple time series on one graph such that it shows the ...

1
vote

1
answer

38
views

### Plot device ON/OFF data in excel

I have following data containing
a device
a timestamp of when the deviced logged the event
an event: ON or OFF
I would like to get a graph that shows per day the duration a device was active (...

0
votes

0
answers

40
views

### Build a plot with data from three different areas to observe trends

I'm working on trace element concentrations in rivers inside a catchment area. I'm always looking at the same two elements, cadmium (Element 1) and aluminium (Element 2).
I have three different rivers,...

0
votes

0
answers

29
views

### 2 labels for one series in the chart bar

I would like to have 2 labels per series used in my bar chart in Excel.
As you see below, I've managed with the labels and their placement & rotation, however, I would like to have them 2 per ...

1
vote

1
answer

41
views

### Excel gannt chart one event with multiple duration

I'm working on a large dataset which I need to plot a timeline in gantt chart fashion (horizontal bars with y-axis the event/task and x-axis time) but one event/task has multiple duration for instance ...

1
vote

1
answer

32
views

### Different appearance for auto-connected blank values in Excel line charts

I have a graph of data that is tracked for my work, but for various reasons it's not feasible to fill in the data for every series. I'd like the line to appear continuous in the chart, so I have '...

1
vote

1
answer

116
views

### Excel xy scatter chart: how do I add vertical lines from horizontal axis up to each data point?

I would like to produce a chart that looks kind of like a bar graph, except the bars (thin lines would be fine, too) would be placed at their actual location respective to the axis. I am well aware ...

0
votes

2
answers

212
views

### Excel - Generate chart axis values as a range from the min and max values in a column

I want to create a chart from a single column that allows the user to enter a year. I want to plot as a bar chart the number of times each year was entered. However, I want the X axis of the chart to ...

0
votes

0
answers

30
views

### Drawing grouped lines (sharing labels) graph in Excel

How to easily and quickly draw multiple lines sharing the same color and label in Excel without writing any scripts? Below is an example table. There are multiple columns having the same name.
A
A
B
...

0
votes

1
answer

71
views

### How to get text glow to properly export to SVG?

I have an Excel chart with some color regions and Black text over them, and I use a "glow" effect, with White color for the glow, to differentiate them from the background. So far, so good.
...

0
votes

1
answer

102
views

### Graph with trend line and up-and-down arrows showing variation

I want create a graph that shows the trend of population (number of residents in the city) across the years. Ideally I would show the trend with a line, but also columns should be fine. The hard part ...

0
votes

0
answers

122
views

### Excel Pivot Table Chart - How NOT to plot any Top 5 items with a zero value OR only plot the first 5 regardless of value

I have created a Pivot Table in Excel and used the Value Filters > Top 10 filter to only show the Top 5 entries based on a particular value.
I have created a Pivot Table Chart based on the above ...

1
vote

1
answer

486
views

### How to use standard deviation calculated in pivot table as error bars on chart?

I would like to draw a graph of the measurement values over time. Here is my pivot table:
There are 6 types of measurements (represented in columns) and 20 points in time (rows). Each measurement was ...

0
votes

2
answers

175
views

### Excel - stacked chart bar doesn't build up new records from 0

I would like to prepare the stacked bar chart in Excel. Unfortunately, the problem I encounter is that data aren't populated from 0, but they are added up to already plotted values like you can see ...

0
votes

1
answer

448
views

### When making a chart, how can I split values into series based on some other column value?

I want to make a chart of bw(qnb), split into 2 series. One serie where offload=0, one where offload=1.
Is there a way to specify a filter when defining a series?
If I select the whole column it will ...

1
vote

1
answer

287
views

### How to combine time interval data on excel

I have a set of data for internet usage for two people. For each person I have each time they logged in and out of the internet over a day. I want to make a bar chart/histogram where the x axis is ...

0
votes

1
answer

80
views

### Wrong order of intervals in Pareto chart

I have some table with 2 columns of data. First one is project id, other is Time To Market in days (finish date minus start date). Smth like:
Id
TTM
ID-1
23
ID-2
11
ID-3
167
ID-4
2
ID-5
40
I'm ...

0
votes

1
answer

402
views

### Line Chart vertical grid lines only for aggregated values (days, instead of hours)

I have two columns: day of week, hours (for each day) and number of things occurring on each hour of a specific day of week.
Below an example with first two days:
I want to plot these data as a line ...

0
votes

2
answers

72
views

### Excel Chart: multiple datasets having significantly different numbers of digits

I want to show a comparison between number of orders and dollars of shipment track against the cost.
I want to make a chart using this data, however, the numbers have huge differences to put them into ...

1
vote

0
answers

52
views

### Trying to create a line chart for multiple Vendors/Products

I have a worksheet that looks like this:
This is just a sample. The full sheet includes multiple dates and vendors. On a separate sheet I am trying to create a line chart with the following features:
...

1
vote

2
answers

37
views

### EXCEL: chart numerosity of items along time based on start-end date

I don't know how to explain better my case so I will go strait to the practical example:
I have this excel table:
Computer
Date Start
Date End
Server1
2022-01-01 00
2022-02-10 00
Server2
2022-01-02 ...