# Questions tagged [charts]

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

**0**

votes

**1**answer

48 views

### How to get Excel to graph multiple series where series are “mixed” in a table? [duplicate]

I've got a table that contains multiple data series - and they aren't uniformly distributed either. Example below. As you can see there are multiple series here: Income, Short-Term Capital Gain, and ...

**2**

votes

**0**answers

41 views

### Excel 3D Flat Map

I am trying to display some data on the flat version of the 3D map. But unfortunately the map cuts off down the middle of the pacific ocean so half my data is on one end of the map and the rest on the ...

**0**

votes

**1**answer

27 views

### Excel: Add multiple tables into a single stacked column graph

I have been asked to make graphs of some evaluation forms, however I don't see how to make readable graphs with the data they gave me:
Every group has its own little table with data, the graph they ...

**0**

votes

**0**answers

30 views

### Excel Resizing axis label area

How do I resize the axis label area and make the long labels wrap?
The textbox formatting options are grayed out.

**1**

vote

**0**answers

15 views

### How to perform automatic graph range extension in Excel (with a constrain)

I'm having a hard time trying to make a graph's range extend automatically. I have made my research and I found this instructive:
https://www.officetooltips.com/excel_2016/tips/...

**0**

votes

**0**answers

17 views

### Animating Bar Charts in Microsoft excel andPowerpoint

I have quarterly data for the no. of Patients and I have to make Bar chart, I want to set the animation in a way to appear the recent quarter bar first and on the right side of the graph and then all ...

**1**

vote

**0**answers

13 views

### Properly formatting box and whisker data in Excel

I'm doing some social media reporting for my company, and want to look at the statistical distribution of Twitter posts. The dependent variable is the engagement rate (defined as a %) and the various ...

**1**

vote

**1**answer

34 views

### Combining categories in charts

How do I combine "Chicken", "Moose" and "Pork" into one "Meat"-name, and the remainders into just "Seafood"?
I would also want to show how much of the "meat" and "seafood" are "fresh" and "frozen"?

**2**

votes

**1**answer

53 views

### It is possible to create grouped charts in Excel?

I have many variables with the same time scale, Is there any way to create a grouped chart in Excel?
Something like this:

**0**

votes

**1**answer

40 views

### Excel 2013 chart - setting time intervals in vertical axis

I have time (mm:ss) in the vertical axis of a bar chart.
I want to set the following parameters:
min - 0
max - 12:00
major ticks: every 2:00 min (0, 2:00, 4:00, etc.)
minor ticks: every 0.5 min (0:...

**0**

votes

**1**answer

28 views

### Why is Excel not sorting the X axis

I have a number of points where the X value is a number. Excel sees it as a number. But when displaying the chart, it does not sort the X axis.
Why?

**0**

votes

**1**answer

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

**1**

vote

**1**answer

35 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

44 views

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

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

19 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

39 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

50 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

**1**answer

21 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

23 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

**1**answer

28 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

31 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

69 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

55 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

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

**-2**

votes

**1**answer

46 views

### PowerPoint Slideshow Error: Server application, source file, or item can't be found

When I double click charts embedded in my PowerPoint slideshow, the following error shows:
The server application, source file, or item can't be found, or returned an unknown error. You may need to ...

**0**

votes

**1**answer

81 views

### How to create two-dimensional column chart in Microsoft Excel for Office 365

I would like to create a two-dimensional column chart in Excel. On the x-axis I would like to plot % of Net Sales, and on the y-axis I would like to plot Gross Margin %. Here's an example:
You can ...

**0**

votes

**1**answer

28 views

### Excel 2010: Create a column chart that groups items and then charts them by year

I am having no end of angst trying to build what I thought would be a simple column chart. My data are in three columns: Player in Column "A", Year (from 2005-17) in "B", Points for each year in "C". ...

**0**

votes

**1**answer

30 views

### Excel Chart, How to only show monthly/weekly/biweekly data

I currently combine weekly data with daily data for an excel chart.
How can I select my data so it is consistenly weekly? Or is there a chart feature to only include the weekly data? I don't want to ...

**1**

vote

**1**answer

68 views

### Excel 2016: 3D column chart with transparency and no gap

I'm trying to make a decent-looking chart using a 3d representation of three different datasets (3 years, 12 monthly values).
If I try with an area chart, I have peaks/valleys at the single data-...

**0**

votes

**0**answers

15 views

### Aligning scatter points to non-stacked bar charts for multiple series

I am trying to create a combination non-stacked bar and scatter plot, where the scatter plot is aligned to the top of the bar chart. My issue is I am comparing two data series for each identifier, in ...

**1**

vote

**0**answers

37 views

### Need expanding chart where values per custom user text are counted

Sorry if my question is not clear but I'll explain in more detail here.
I have a worksheet that calculates what percentage of a specific users events are mistakes. It figures this out by taking ...

**0**

votes

**1**answer

35 views

### Where can I find this kind of line graph?

I have this data gave to me in excel spreadsheet
2017 2018
Month Sales TC TA Month Sales TC TA
Jan -0.08 -0.08 0 Jan 0.02 0 0.02
Feb -0....

**0**

votes

**1**answer

68 views

### How to plot horizontal lines in scatter plot in Excel

I would like to plot a time series with two horizontal lines (depicting limits in my case).
How do I do this?
Example of what I'm trying to achieve (horizontal lines drawn in Paint):

**0**

votes

**1**answer

26 views

### How to define a graph, based on automatically changing data?

I have an Excel sheet (called Sheet1), where I regularly add some data. By pushing a button, a summary of that data gets written on a next page (called Evolution), and on that next page, there's also ...

**0**

votes

**0**answers

31 views

### Excel: combine Contour chart with scatterplot

I am able to create a Contour (2D-Surface) Chart. But I can't manage to add points into the Chart like a Scatterplot.
I want the Contour Chart to act as a background for my Scatterplot.
In the ...

**1**

vote

**1**answer

40 views

### Excel bar chart widths displaying incorrectly

Using the following data to create a bar chart displays incorrect bar widths.
Yes No
a 7 0
b 7 0
c 6 1
Shows
As you can see, the widths for c are incorrect. The 'No' column is ...

**0**

votes

**1**answer

43 views

### Unicode character for two *vertical* tildes next to each other? What is that symbol called?

Sometimes on graphs, there is a symbol used to indicate a part of the graph has been ellipsed over to make the graph more compact.
It looks something like this: (poor MSPaint mockup)
What is that ...

**1**

vote

**1**answer

40 views

### The graph making tool interprets my data… weirdly

I have sheet from which I attempt to import some data to a graph:
However, as you can see, the x-axis labels are not imported either as text nor as dates, but with the first two ciphers correct, and ...

**1**

vote

**0**answers

14 views

### Display convergence of property in X/Y diagram [closed]

I want to display a diagram, where a property Concept/Realization are shown as points OR multiple projects with the same value in that property (0%,100%;0%,100%;...) can be pulled into a shared bubble
...

**0**

votes

**1**answer

49 views

### Excel - Bar chart - years in y-axis and variables in x-axis

I'm trying to chart the following:
I want a bar showing the total fruit
I want the fruit in the Y-axis
The years in the X-axis - so you can visually see the impact per year of each category.
...

**0**

votes

**1**answer

22 views

### The upper data series won't plot a line

I'm planning to plot two series of data on a single graph. The bottom axis is the year. I suspect that they wont plot the upper series because both don't share the same intervals. 2-year intervals for ...

**0**

votes

**1**answer

30 views

### how to dynamically get an update excel radar chart?

Scenario:
An excel form that saves some scores.
Each row represents a candidate.
Each row has 8 topic cells with an integer score.
I can get a nice radar chart that shows each candidate with the ...

**0**

votes

**1**answer

48 views

### Scatter graph to show margin and revenue for a series of projects

Can a scatter graph show non-chronological data - For a series of projects I want to plot the margin on the Y-axis and the revenue generated on the X-axis. Projects will change position each month as ...

**1**

vote

**1**answer

130 views

### Plotting time of day distribution in Excel

I have data in excel which lists several events as a time-of-day, in a single column for each day, like so:
1/1/2018 2/1/2018
10:23 00:23
14:53 13:14
16:01 14:19
23:01 16:...

**1**

vote

**1**answer

48 views

### How to make an excel chart for sales data by year and department?

Assume data like this:
Year Dept Sales
2015 Digital 150,000
2015 TV 250,000
2015 Print 100,000
2016 Digital 300,000
2016 TV 245,...

**2**

votes

**2**answers

28 views

### Can Excel generate a percentage chart from a column with CSV values? How?

Not sure if this is even possible. Its as follows, imagine the following excel sheet:
STOCK|VALUE|TAGS
ABCDE|10000|Z,X
FGHIJ|20000|X,Y
KLMNO|30000|X,Y,Z
PQRST|10000|Z,Y
Total|70000|
Now somewhere ...

**1**

vote

**1**answer

232 views

### Exporting Access query to Excel using VBA and creating a secondary axis chart

In MS Access I have a database. I have Form with three TextBoxes and one Command Button.
In txttask_plot user writes Plotid
In txttask_from user selects date1
In txttask_to user selects date2
The ...

**0**

votes

**1**answer

98 views

### On a line chart with a date axis, I want to label each time the “experiment” was checked with 1, 2, 3 etc

My data can be imagined as checking an experiment regularly, recording its values for the line graph, and recording the time it was checked. The times where the experiments were observed were ...

**0**

votes

**1**answer

94 views

### Copying Chart to Another Sheet with Updated References in Excel

I have made a chart within a sheet in Excel. Within the sheet, the chart refers to specific cells in the sheet to display (i.e. cells that contain my data points).
I would like to know how to copy ...