Questions tagged [charts]
Graphs, charts and other graphical methods for showing data and their relationships.
0
votes
0answers
9 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:
example
...
0
votes
1answer
20 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
25 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
55 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
1answer
30 views
How to generate multiple charts in Excel from same data? [closed]
There is a data set of 3500 rows (X and Y values) in Excel. How to automatically generate multiple charts (in different sheets) for every 50 rows?
0
votes
0answers
9 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
35 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
50 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
23 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
18 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
39 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
40 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
39 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
13 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
44 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
26 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
12 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
123 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
46 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
82 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
97 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
42 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 ...
0
votes
1answer
22 views
How does one fix the position of a text-box or drawn shape on an MS-Excel-2010 graph (under WIN7)?
Having positioned an arrow shape and a small text box onto an MS-Excel-2010 graph, when I re-position the graph, the shape and text-box don't move with the graph.
Can anyone please advise me how to ...
0
votes
1answer
43 views
Clustered Column with same row values
I can't seem to get a good clustered column when the row values are the same. How do I create a chart that has the same row value title but a different x axis title? For example, in the image below I ...
-1
votes
1answer
69 views
In MS Excel, how can I create a bubble chart where the color of the bubbles match the color of a cell?
I would like to illustrate a fourth variable (x axis, y axis, bubble size, bubble color), but do not want to artificially split the series into pre-defined groups based on a set of thresholds. Rather, ...
0
votes
2answers
24 views
Creating a scatter plot with 4 or more data columns fails, whereas it works with only 3
I have a CSV file that I'm importing into Excel. It's formatted like this:
Time Var1 Var2 Var3 Var4 .. VarN
0 1 1 1 0 .. 0
1 1 0 1 0 .. 0
2 0 0 ...
0
votes
2answers
58 views
Irregular intervals in Excel graph
As you can see in the image, I need to have irregular intervals but to have that I tried to leave 6(for 60 min) empty columns to have that gap but that makes it not draw or connect the first point to ...
0
votes
1answer
12 views
Y Axis on Bar Chart in Excel has three equal data points, but should have only 1
I have a chart in Excel from this data
September-17 March-18 April-18
Division Work 1 0 0
On-Wing Work 0 1 ...
0
votes
1answer
125 views
How can I combine three cells (e.g. '23','7','10') to form an 'hour/day/month' cell?
My idea is to have this 'date format' cell in order to graph prices that corresponds to each hour and have a around 10.000 rows of information for every year. This is what it looks like when I ...
0
votes
1answer
48 views
Automatic formatting of axis in Excel stacked bar chart to start at start date?
I have used this blog https://peltiertech.com/excel-gantt-charts/#comment-1455520 to create a Gantt chart in Excel that acts as a template for others to input their information (i.e. tasks, start ...
0
votes
1answer
58 views
Is there a way to have 'Inside End' and 'Outside End' labels on a single axis Excel bar chart?
I have a dashboard with a typical bar chart that only has 'Inside End' labels on it (percentages usually). This dashboard is can vary depending on which variable I pick (i.e. if I pick a different ...
0
votes
2answers
92 views
Excel: Display two currencies on graph axis
I am trying to display two currencies on the y-axis. I do not want two y-axis. Essentially, I am presenting to two audiences; some from South Africa (hence Rand), and some from the Netherlands (hence ...
0
votes
0answers
15 views
Macro to allow copying/pasting of chart when sheet is protected
I am creating Excel-based dashboards and want to be able to copy and paste charts to another application when the sheet is protected. I do not want the charts to be edited so I have left the box for "...
0
votes
1answer
20 views
Excel: Chart Event times for teams [closed]
I have a dataset that looks like below:
Team Start End Days
1 5/22/18 8/13/18 83
2 5/24/18 6/30/18 37
1 5/28/18 7/10/18 43
2 6/4/18 8/10/18 67
3 6/6/18 6/26/...
0
votes
1answer
160 views
Prevent two sets of labels from overlapping in a bar chart
I have a bar chart in a dashboard that needs to be dynamically updateable. I've inserted two graphs in order to have two sets of labels in different places.
Unfortunately, when the value is 0 or No ...
0
votes
1answer
33 views
don't draw line in a line chart for N/A cells
Edit: I try to clarify my question, since the replies given so far don't answer it.
If in A1:A5 I have (empty lines describe empty cells):
1
2
3
4
I get the following chart:
that is what I need.
...
0
votes
0answers
62 views
Find the percentages of given parameters for over 65,000 rows
I have over 65,000 rows of data of numbers ranging from 1 to just over 800 and I need a way of displaying the percentages of number of rows that have a given parameter, e.g. the percentage of rows ...
0
votes
0answers
20 views
Prevent pie chart from displaying values less than two
I'm trying to create a pie chart in Excel that only shows data that has a value greater than one.
My data is not the result of a formula, and is just raw text. I still want the original data to be ...
0
votes
1answer
32 views
Looking for a formula for automatic member placement
Chart 2
Chart 1
Chart 1b
I have a group page, and to keep track of my members' presence/absence, I created this.
In chart 1, I manually have to write who's active/inactive. They have to be ...
1
vote
1answer
33 views
Creating a combo chart with bar and data icons
I'm not sure if this is even possible. I'd like to create a chart like so:
My data source is a pivot table with 3 columns - Category, Revenue and Growth (a calculated field).
I'm thinking of a combo ...
-1
votes
1answer
34 views
Scatter plot for multiple rows
I'm trying to plot the following data in Excel using a scatter plot
Income 1960 1961 1962 1963 1964 1965
Algeria 1280 1085 855 1128 1170 1215
Argentina 5251 5448 5316 ...
0
votes
0answers
71 views
Graph and organize multiple categories with multiple data series each
I'm trying to organize and graph data on some cooling devices in a way that's expandable and easy to modify, i.e. graph only certain coolers, manipulate data/add new calculated data as needed.
Here ...
0
votes
1answer
13 views
Combo Chart not selecting data correctly
I can't figure out why the combo chart is not treating the second LA as the start of the line graph series. It knows what to do with MS and TX, but is making LA another bar instead of a line. ...
0
votes
0answers
16 views
How to create a agrregated chart by column in excel?
I have a spreadsheet with Excel and I would like to know how can I create a chart grouping the data by a specifique column. For sample, I have a table with 3 columns, Item, Category and Price. I would ...
0
votes
0answers
85 views
Histogram: use sum, not count
Let's assume I have the category "Accidents per Year" (x-axis) and "Frequencies" (y-axis).
The first line would read like: "866,062 people had 1 accident this year". Now I want to create a histogram ...
0
votes
1answer
25 views
How to make multiple legends the same on a graph
I have a graph of 30 categories. Each category consists of about 200 entries.
I would like to make groups of 5 look exactly the same on a graph, so that, for example, categories 1-5 are all ...
0
votes
0answers
14 views
Creating excel bar chart with differently formatted columns
I am working on creating a bar chart in excel. I am almost done with the bar chart and have produced the first graph shown below. I would like to modify the chart I have produced so far to look like ...
