# Questions tagged [charts]

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

**0**

votes

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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