Questions tagged [charts]

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

Filter by
Sorted by
Tagged with
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 ...
  • 1
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:...
  • 33
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 ...
  • 91
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 ...
  • 171
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 ...
  • 1
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" ...
  • 101
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 ...
  • 31
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 ...
  • 31
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 ...
  • 1,107
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 ...
  • 118
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 ...
  • 1
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 ...
  • 1
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:...
  • 765
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,...
  • 103
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 ...
  • 1
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,...
  • 133
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 ...
  • 103
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 '...
  • 113
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 ...
  • 542
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 ...
  • 101
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. ...
  • 8,073
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,207
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 ...
  • 251
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 ...
  • 103
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 ...
  • 355
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 ...
  • 101
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 ...
  • 11

1
2 3 4 5
30