Questions tagged [charts]
Graphs, charts and other graphical methods for showing data and their relationships.
0
votes
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
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
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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 ...
