# Questions tagged [charts]

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

**0**

votes

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

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

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

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

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

**1**answer

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

**1**answer

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

**1**answer

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

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

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

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

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

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

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

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

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

**0**answers

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

**1**answer

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

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

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

**1**answer

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

**0**answers

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