Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

Questions tagged [charts]

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

0
votes
0answers
14 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
17 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
92 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
23 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
30 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. ...

15 30 50 per page