Questions tagged [charts]
Graphs, charts and other graphical methods for showing data and their relationships.
0
votes
0answers
19 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
18 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
1answer
20 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
0answers
20 views
Simple Excel bar Graph
I am trying to make a very simplistic graph and am not sure if how to do this in Excel. I have monthly claims data (ie: $15M paid in July). I am trying to have a singular vertical bar that has at is ...
0
votes
2answers
29 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
98 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
24 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
55 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 ...
-1
votes
0answers
43 views
Making a bar graph with dummy column in Excel
I need to create a graph just like the one shown in the picture i attached. it does not need to have the curve, rectangular bars would be fine. but the axis should be the same. from what i searched, i ...
0
votes
2answers
51 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
14 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
19 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
38 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
31 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
18 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
25 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
52 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
12 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
33 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
17 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
13 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 ...
0
votes
0answers
39 views
Excel Chart with two Y axes [duplicate]
I have a question about creating an excel chart with two Y axes. Suppose I have the following data:
Horizontal Axis Primary Vertical Axis Secondary Vertical Axis
Series 1 1 ...
2
votes
1answer
24 views
Excel 2016 - Offset dynamic height & waterfall chart
I've been trying to get a waterfall chart to adjust dynamically but don't appear to be able to get the offset working. I don't know if it is a limitation with my knowledge, the chart, or the function....
0
votes
0answers
17 views
Bug resolution time graph
I'm documenting the amount of time it takes for a bug to be resolved but displayed in histogram/binomial format to see what the average amount of time it takes to resolve a bug. I was using pivot ...
2
votes
0answers
34 views
When I try to edit Y-axis limit on LibreOffice, the data in the chart disappears
Has anyone encountered such an issue? Am I missing something?
When I choose axis limits manually from Right Click > Format Axis > Scale, the data in the chart disappears or gets hidden. I am ...
3
votes
1answer
27 views
Excel - Dynamic Charts
I have a series that looks like SERIES('Data'!$C$140;'Data'!$E$138:$Q$138;'Data'!$E$140:$Q$140;2) and in order to make it dynamic I'd like to replace the endpoints with a cell that depends on the ...
2
votes
0answers
71 views
Automating creation of this chart in Excel 2016
I am trying to figure out a way to create this graph automatically on Excel and link it to PowerPoint so that when the data in Excel gets refreshed, the PowerPoint chart gets updated as well. ...
0
votes
1answer
15 views
Excel: time series with markers for events
I have daily data for two stocks for about 10 years, and sometimes there are some specific events (such as an announcements or a political events, not numerical data) I would like to show on my graph. ...
0
votes
0answers
34 views
OSX Numbers, extending a chart data series
This link shows how to add a cell to a data series on a chart. However, my chart was imported from Excel and is several years old with over 150 columns and about 50 rows. I want to chart several of ...
0
votes
1answer
67 views
create excel charts in separate sheet using vba
In Excel 2016, I am trying to write a vba sub that takes a worksheet containing some data and creates a new sheet which will be filled with charts that use the data in the original sheet.
I have ...
0
votes
1answer
29 views
Linking a table to a pie chart and basing that chart on certain criteria
I need to create a pie chart from the numbers in this table:
But I first need to sort them into categories like this:
It needs to be linked so the pie chart would update if the numbers change.
Any ...
0
votes
0answers
17 views
making an instance pie chart in excel 2010
I have an excel document with lines of data and each instance is listed out by a 100, 200, 300, 400, and 500 number. I would like to make a pie chart of how many 100's, 200's, 300's etc. There will ...
0
votes
1answer
28 views
Date as X-axis in Excel
Excel "latest" version (very recent at least, with the Ribbon interface, 2018).
Fighting with dates to be used as X-axis labels in a chart.
The data below came out of a Pivot table; when selecting ...
0
votes
2answers
303 views
Is it possible to do scale break on excel?
I need to create an excel column chart where one of the series has exceptionally big value while the rest have smaller value. I am using the same unit for all values. Here is part of the data I want ...
0
votes
0answers
20 views
Adjusting the fontsize for individual datapoints
I have a chart in which i plot a number of points, depending on if a number has been entered for them in a different sheet.
Graph:
Source data:
The source data are set to the correct columns in the ...
0
votes
0answers
18 views
Excel 2010 line chart bizarre date axis behavior
In Excel 2010 I have a line chart with dates on the x-axis. The Auto dates range from 1/1/2006 to 12/31/2018.
See 1st image attached:
The chart displays as expected. I tried to make one change: ...
1
vote
1answer
49 views
Google Motion Chart not loading
At the following link, there is a motion chart example that is supposed to demonstrate how the motion chart works:
https://developers.google.com/chart/interactive/docs/gallery/motionchart#example
...
2
votes
1answer
268 views
Excel Pivot with percentage and count on bar graph
Is it possible to create a Pivot bar graph that Shows percentage and Count in the same bar? I only have Excel 2010
MWE:
Firm Product
1 Car
2 Ship
3 Car
4 Ship
5 Car
I can easily ...
-2
votes
1answer
103 views
Excel scatter plot x axis displays only sequential numbers but not real data selected for x axis
I have an excel scatter plot with 5 different data series on single chart. First 4 series are working well. When I want to add a new series with similar x-axis data (0.0, 0.4, 0.9 .. ) the plot is ...
0
votes
0answers
33 views
How to show number labels on the minor divisions of the Y axis in Excel
How do I show number labels on the minor division of the Y axis in Excel 2011? For example, between 1,000 and 10,000 on the chart below, can I add labels like 3000, 7000, 8000 to the axis?
0
votes
1answer
17 views
Excel 2007 Graph scale showing blank dates
I have the below data:
Date Planned Complete Carry Over
11-May-18 1 0 1
15-May-18 3 0 3
16-May-18 6 0 6
When I insert a Bar Chart, it is ...
1
vote
1answer
21 views
Click on chart to activate hyperlink EXCEL
Is it possible to use a mouse click on a chart to trigger a hyperlink ?
(the hyperlink will be to a place within the document)
It can be done on images and shapes, so can this also be done on charts ...
1
vote
1answer
63 views
Changing the interval values on line chart x-axis
I'm plotting two functions onto a line chart, and I need to change the values on the x-axis. The graph is linked at the end of the question, along with the table that the values are sourced from.
...
0
votes
1answer
136 views
Have Excel Chart only show current month and YTD
I’m currently working on creating a dynamic chart which is updated monthly in accordance with the information imported into the excel file.
The table is updated with the information, where the chart ...
0
votes
1answer
33 views
How to calculate transformed axis values in Logarithmic scale in Excel chart
What is Excel doing exactly when you tick the "logarithmic base 10" box under Format Axis?
It is taking log10, and then applying another transformation to get the transformed axis?
This is base on ...
