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

**2**

votes

**2**answers

19 views

### How to add padding to images/chart in MS Word with 'in line with text' wrapping?

I have a justified paragraph at the end of a two column page. On inserting a chart with "in line with text" mode under text wrapping in the middle of the paragraph, the image appears fine.
How can I ...

**2**

votes

**1**answer

16 views

### Excel grab address to start y values series

I have the string $F$50 created by the CONCATENATE function.
I also have a scatter plot where the selected data is like this:
=SERIES(,data!$A$4:$A$404,data!$F$4:$F$404,1)
I want to replace $F$4 in ...

**3**

votes

**1**answer

39 views

### Can this 5-attribute 2D risk map be built in excel?

So there is this risk map (or heat map otherwise) below (*):
What is interesting is that in the a 2D image there the following attributes are mapped:
Attribute -------- Drawing component
1. ...

**0**

votes

**2**answers

26k views

### Scatter chart, with one text (non-numerical) axis

Lets imagine I manage 100 pizza stores. I want to plot a chart each day, of how long deliveries are taking.
My data might look like this:
London 23
London 22
London 44
London 18
...

**0**

votes

**1**answer

4k views

### Plotting quarterly and monthly data in Excel

I have one monthly data series in one spreadsheet and one quarterly in a different spreadsheet. What is the "smartest" way to plot them together in one graph (in Excel)? Its quite a lot of data, so I ...

**0**

votes

**0**answers

25 views

### Excel - Adding titles to both ends of an axis in a scatter plot

I'm looking for a way to add axis titles to both ends of an axis in a scatter plot in Excel 2016 for Mac. So far I have titles only in the left and bottom parts and want to add the titles on the ...

**0**

votes

**1**answer

2k views

### Excel scatter graph fill inside shape

I would like to fill the area between two graphs.
My data is in the following format:
x y
0 0
1 1
2 4
....
0 0
As you can see they start and end at the same point. For my data it draws a chart ...

**2**

votes

**3**answers

13k views

### How to highlight data points in a scatter chart in excel?

I have a scatter chart with a series of numbers in Excel. Most of the time, those numbers are high (>1000). I would like to display the scatter chart with those numbers in the default color, but if ...

**1**

vote

**1**answer

29 views

### Plotting multiple datasets of different lengths on the same scatter graph in Excel 2010 (extended)

I would like to plot multiple datasets of different length on the same scatter graph. This question was already answered exactly here:
Plotting multiple datasets of different lengths on the same ...

**0**

votes

**1**answer

2k views

### excel - how to connect a graph max with original (0,0) point

If I have a spreadsheet that has the following data:
A
0 0
1 2
2 4
3 4
4 6
0-4 X Axis
A is Y Axis
First point is (0,0)
Second Point is (1,2)
Third point is (2,4)
...

**0**

votes

**1**answer

3k views

### How to combine Excel charts on same X-axis

I want to create two stacked graphs in one chart object. One should be Stacked Column, and another Stacked Area. They represent revenue per partner per week of the year. On x-axis are weeks of the ...

**0**

votes

**0**answers

10 views

### Using I/O graph how to interept bytes/tick against packet details information?

I'm working on a trace-file which has reported ISP throttling occurrences in it.
My task is
to use IO graph to understand at what point in time the throttling process effected client upload ...

**0**

votes

**1**answer

4k views

### Excel chart with a single x-axis but two different ranges (combining horizontal clustered bar and horizontal stacked bar), possible?

I am new here. I have a data set of density values (phytoplankton community) according to depth and the composition of it in percentage. I want to ask if it is possible to construct the density values ...

**0**

votes

**2**answers

42 views

### (Excel) Plotting data series and a subset of that series on one chart

I have a data series associated with text labels. I'm trying to fit a line to the second half of my data. I read that in order to do so I have to make a second data series consisting of the subset of ...

**6**

votes

**5**answers

62k views

### How to change x-axis min/max of Column chart in Excel?

Here i have a column chart of binomial distribution, showing how many times you can expect to roll a six in 235 dice rolls:
Note: You could also call it a binomial mass distribution for p=1/6, ...

**0**

votes

**1**answer

3k views

### How to create a 4 variables chart in excel? [closed]

I have been trying to figure out a way to create a chart with 4 variables in Excel. I can get to 3 with no problem but the 4th variable seems not possible.
Here is my data (I am working with decoding ...

**3**

votes

**1**answer

3k views

### Create progress bar or milestone type graphs in Excel 2007

I want to display project progress in Excel 2007. Is there a way to show a progress bar like graph filled for completed percentage and empty until end date for a milestone or the whole project? It ...

**1**

vote

**1**answer

1k views

### What are the labels for minor ticks in a log scale graph? [closed]

What are the labels for the minor ticks in a log scale graph?
I would like to label them. So, I want to know how to calculate the value for each of the minor tick.

**1**

vote

**1**answer

84 views

### Excel chart for rail car movements

I need to display the movements of a group of rail cars between two locations.
Each car has dates for "left location A", "arrived location B", "left location B", "arrived Location A" - repeatedly ...

**1**

vote

**2**answers

50 views

### Creating a chart with two different scalings on the y-axis [duplicate]

I want to create a chart with two different scalings (steps of 500 and steps of 10.000) on the y-axis.
This is needed because there is a fixed cost of 1000 (so a straight line from left to right) and ...

**0**

votes

**1**answer

314 views

### Excel 2013 charts - how can I setup default chart with distinct line colours and fonts as in Excel 2003

The default line colours in Excel 2013 have poor contrast and are not easily distinguishable. I would lie to use the same chart colours, fonts, borders, symbols etc. as was in Excel 2003. How can I ...

**2**

votes

**1**answer

36 views

### Excel pivot table - unable to get graph to display correctly

I have a pivot table (Excel 2013) of results for a helpdesk. In column A it lists the agents, grouped by year (this divides up into months). In column 2 it lists the number of tickets closed by each ...

**2**

votes

**1**answer

18 views

### generate line graph from spreadsheet with month and category column?

Trying to generate a line graph that shows the amount a certain category happened per month. The spreadsheet has the category of an instance as well as the month it occurred. Easy way to do this?
...

**0**

votes

**2**answers

45 views

### Day of the week and Time Graphing in Microsoft Excel

I have an Microsoft Excel document with two columns, date (mm/dd/yyyy) and time HH:MM(a/p). Each row represents an order (The day it was placed and the time it was placed).
How can I graph this so ...

**2**

votes

**1**answer

3k views

### How do I create a PivotChart from a subset of PivotTable data?

As part of a dashboard, I've created a PivotChart from a PivotTable in Excel 2010, but the PivotTable includes extra columns that are cluttering up the chart. But when I adjust the values list on the ...

**1**

vote

**4**answers

28k views

### Excel or PPT: How to have two pie charts, but one legend

I would like to design a slide that shows two pie charts of the same size side-by-side, but with a single legend that is centered on the page beneath both charts. I can easily create one of the pies ...

**1**

vote

**1**answer

84 views

### How to make a concentric pie chart in Excel?

I'd like to make a chart (preferably on its own sheet) that is a combination of a regular pie and a doughnut. The regular pie sits in the middle and the doughnut surrounds it.
I have seen those ...

**0**

votes

**1**answer

40 views

### Forcing axis units in Excel 2013 plots, being written after minimum bound of axis

I have a plot, drawn in Excel 2013. The data begins from almost 0.9 to almost 5.1. I want the x axis to be written from 1 to 5 and to show the data from 0.9 to 5.1.
Upon my best effort, I could set ...

**0**

votes

**1**answer

23 views

### How to include image(.png) in legend of an excel chart?

All,
I am trying to include company logos as legends of excel charts instead of their names automatically using VBA. Any leads will be highly appreciated.

**0**

votes

**1**answer

26 views

### How to chart two columns of data in excel

I have the following data and I want to create a simple chart in Excel 2010 but can't work out how to get this to work. I've tried scatter charts, switching axes, etc. and nothing seems to give me ...

**0**

votes

**1**answer

13 views

### GraphViz gui crashing on rendering

I have a .dot/.gv file that is a DirectedGraph with about 55,000 edges. When I try to render it using the GraphViz GUI in OsX it just sits a Not Responding state in Activity Monitor. I would assume ...

**0**

votes

**1**answer

30 views

### Bar chart from data in one column in Excel

Call me stupid but every time I want to perform an easy task in Excel I end up using Google to find a solution. Today's mission impossible is to create a bar(or pie) chart from data located in one ...

**2**

votes

**1**answer

51 views

### Data retention on storage devices?

Is there any official table out there that shows how many years can a storage device retain data before it becomes unreadable?
Storage devices: USB memory sticks, classic hard drives, SSDs, optical ...

**0**

votes

**2**answers

40 views

### Adding a Secondary Axis to an Excel Chart creates gaps

I am trying to lay a line graph (on a secondary axis) over an area graph in Excel. When I have just the area graph, the graph uses the full width of the graph area. When I add the line graph and move ...

**0**

votes

**1**answer

38 views

### Plot graph in MS Excel using multi axis

I have a table with many of lines (alice, bob, etc.) per each date:
x line y
2015-04-10 alice 11032024
2015-04-10 bob 1492804
2015-04-10 clown 845033
2015-04-10 mary ...

**0**

votes

**0**answers

29 views

### How to update chart on cell click event in Microsoft Excel?

I want to create mark reports for N number of students. Each student's daily based marks on three subjects(Subject1, Subject2, Subject3) should be recorded. Each subject has two types of marks such as ...

**6**

votes

**6**answers

27k views

### When embedding an Excel chart on a PowerPoint slide, why does the text look awful?

I have a recurring problem with Excel 2003/PowerPoint 2003, where I have a nice-looking chart in Excel and try to embed it on a PowerPoint slide. Quite often, the text in the chart (labels, axis ...

**1**

vote

**2**answers

11k views

### How to Superimpose 2 Stacked Column Charts in Excel

I have two stacked column charts (with no gaps between the columns) that have identical X- and Y-axes with same intervals. One graph is displayed in red, while the other graph is displayed in blue. ...

**2**

votes

**2**answers

22k views

### Finding X on Excel scatter plot/trend line

If I have some data in an scatter plot in Excel, e.g.
X Y
1 10
2 20
3 30
4 40
5 50
and I want to find the Y value for X = 10, or X=3.5, or whatever (obviously this is a simplified example) I've ...

**0**

votes

**1**answer

875 views

### Line chart from multiple tables in Excel 2013

I have two sheets, "Graphs" and "Data".
In "Graphs" is a line chart with a single line that gets X and Y values from tables in "Data". I want the chart to be updated automatically when I add ...

**1**

vote

**1**answer

45 views

### Add an area to a scatter plot in Excel

I'm desperately trying to layer an area chart on top of a a scatter plot in Excel 2013.
The scatter plot has been successfully used to visualize the deviation from the mean of different Key ...

**0**

votes

**1**answer

44 views

### Chart created from range of dates includes dates not in source data

I have a chart and its source data is read from a range which contains dates. When I plot it out into a chart, the x-axis includes dates that are not included in the range.
How do I avoid this?
For ...

**1**

vote

**0**answers

46 views

### Excel Charting - How to edit the X axes for positive value on both sides?

I have a stacked chart, with the X axes at bottom. So there are two bars protruding along the y axes from each category. to get an idea of the X axes, it's something like this
How to plot positive ...

**2**

votes

**3**answers

5k views

### Vertical Histogram in Excel with Conditional Formatting

I'm able to do data bar conditional formatting in Excel 2010, but I can't figure out how to switch the bar axis to make it vertical. Is there any way around this? Can I simulate a vertical histogram ...

**0**

votes

**1**answer

125 views

### MS Excel - adding line to some series in stacked bar chart

I built the following chart after some googling:
It has two levels of category axes, the bars you see are stacked bar chart types. You can find the file with the data and the charts here if you ...

**-1**

votes

**1**answer

47 views

### How can I create a chart to show a possible pattern [closed]

I have 3 columns in my table.
Date Day of Week # of hours
11/27/2013 Wednesday 7
2/4/2015 Wednesday 7
3/18/2015 Wednesday 7
5/2/2013 Thursday 2.5
5/15/2013 Wednesday 2.5
...

**1**

vote

**3**answers

3k views

### how to extract data from an image graph

I'm looking to get that from a graph. but problem is that graph is in image form. Now I want to extract data in excel from that graph. how can i do it? I'm using office 2003.

**0**

votes

**1**answer

50 views

### Plot two columns against eachother

I don't think this should be difficult, but I'm pulling my hair out trying to do it.
I am trying to make a chart of age vs BMI. I have a column with age and a column with BMI. The table looks ...

**0**

votes

**1**answer

27 views

### Excel 2011 plotting difference between logged sent-time / acknowledgment-time

I have an excel sheet which is a log containing the time that a message has been sent and the time that the corresponding acknowledgment for that message was received. It also contains the time ...

**1**

vote

**1**answer

60 views

### Excel: Get rid of gaps in line chart

I have a table that contains the data with some absent values. If I create a line chart for that, there are gaps in place of absent values, but I'd like to have the line just follow through to the ...