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

**0**

votes

**1**answer

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

**1**

vote

**1**answer

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

**2**

votes

**1**answer

31 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

**1**answer

8 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

33 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

**2**answers

28 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

**0**answers

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

**0**

votes

**0**answers

12 views

### How to make boxplot-like plot with histograms instead [migrated]

I'm making a plot of internet speeds. I want to show the distribution of speeds collected, bucketed by the hour in which they were collected. I'm hoping to obtain a result that looks like
where for ...

**1**

vote

**1**answer

32 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

36 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

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

**0**

votes

**1**answer

79 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

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

**0**

votes

**1**answer

39 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

23 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

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

**0**

votes

**1**answer

44 views

### How can I make a Scattered chart in excel where the dots are different colors?

I have the following info:
Question | Importance | Percentage
1 | 2 | 15%
2 | 1 | 98%
3 | 1 | 35%
4 | 3 | 22%
5 ...

**0**

votes

**2**answers

75 views

### Excel Graph with 2 X-Axis Non-Linear Mapping

I have the following problem someone might be able to help with.
I have two risk scales, one from 1 to 11 (old) and one from 1 to 21 (new), where the mapping is non-linear, i.e. old scale->new scale ...

**1**

vote

**1**answer

29 views

### Different colored columns in excel

I have data such as this:
1 | 2 | Y
2 | 4 | N
3 | 3 | N
4 | 2 | Y
...
I need a bar graph that will display column 1 as the x-axis labels with column 2 as the y values. The color of each bar will be ...

**0**

votes

**0**answers

64 views

### setting upper and lower limit excel histogram

I am using the built-in data analysis tool to create a histogram for a column of numerical data in Excel. I'm doing the same thing for many different files, and they all need to have the same scale ...

**1**

vote

**1**answer

41 views

### Show increase in trendline by using Excel vba

I have data in c5:c12 (sales1) and I plotted a graph and a trendline of this data. I also have data in d5:d12 (sales2). I would like to show an increase, graphically, in my existing trendline by using ...

**1**

vote

**0**answers

41 views

### How to extract contour lines from a surface plot in Excel

I have several surface plots. I would like to combine one contour line from each plot into a single plot. Is there a way to extract the contour line that excel generates?

**0**

votes

**3**answers

65 views

### Display excel grid lines in front of a chart?

I have an area chart in Excel for Mac 2011 that I'd like to display grid lines in front of. Is there a way to do this? I know I could make the chart semi-transparent and show the grid lines through, ...

**0**

votes

**0**answers

16 views

### Decimal axis min/max in Apple Numbers

I'm using latest Apple Numbers 3.5.2 and faced with strange bug: I can't set non-integer axis min/max value, for example 0.5 or 1.75... Numbers just round it to 0, 1, 2. I tried both "0.5" and "0,5" ...

**1**

vote

**1**answer

44 views

### Excel 2013 - Creating 2-data series chart with column width is dynamic (depend on variable)

Using Office 2013 suite (Excel 2013), how to I create x/y graph, we additional dependencies where X columns widths dependant on additional value?
For example, from values such as:
Height Width
...

**1**

vote

**2**answers

48 views

### Excel data layout

I'm wanting to make a chart similar to this:
The data i'm working with is different but the concept should be the same. I'm most curious in how to group x-axis (category) values. In my case I will ...

**0**

votes

**1**answer

72 views

### Excel Timeline Chart (Vehicle Tracking)

Using Excel 2010 I understand how to create a Gantt Chart to simulate a timeline. Very similar to this https://ablebits.com/_img-blog/_comments/gantt-chart-months.png.
My task is a little bit ...

**4**

votes

**3**answers

72 views

### Excel 2013 - Is there a way to turn off a chart series without removing it

This past year i finally switched to Excel2013 from Lotus123, the only task i miss from lotus (that i can't figure out how to do in Excel) is; when formating charts and creating copies of charts it ...

**3**

votes

**1**answer

249 views

### How to plot multiple actual vs target in a chart? Up down arrows? And how to show cumulative?

I have Actual vs Target data for 5 teams. Subset of data table below.
I want to show:
Variance target vs actual
Cumulative progress towards total target
What is the best way to plot this data? ...

**0**

votes

**1**answer

30 views

### Changing Clustered Column Parameters in Excel

I have a quick question about how to rearrange a clustered column chart in Excel for Mac 2011. Here are the links to my data and chart:
Data:
Chart:
I want to switch the years with the ...

**0**

votes

**0**answers

45 views

### Excel chart doesn't show 'value' on hover

I have a combination chart on Excel 2013. It has both lines and stacked areas. When I hover over the lines, it shows all relevant information ('series', 'point' and 'value') of the data point.
When ...

**1**

vote

**0**answers

48 views

### Filtering values on Excel Pivot Chart

I'm importing data into Excel Pivot Chart from SQL Server. I'm trying to filter out Values (decimal type on SQL) below a certain threshold.
For this, I click PivotChart filter and see that filter may ...

**0**

votes

**2**answers

83 views

### Export excel chart to png with certain dimensions

How do i export an Excel chart to a PNG image, defining the exact size of the resulting image file?
I need to export some excel charts to PNG to put them on a html page. Due to design restrictions, ...

**0**

votes

**0**answers

85 views

### Automate (Macro) Excel bubble chart labels using values from cells

Is there a macro which will update Data labels in a bubble chart, when the data series change?
Issue: each time I add new influencers and refresh the charts, the data labels drop out
Each bubble ...

**1**

vote

**1**answer

43 views

### How do I use fill color for negative values in spider chart?

Is it possible format the Spider Chart so that the negative area is always filled with red color and the positives with green.
For clarification:
The color filling is done manually and if the ...

**0**

votes

**1**answer

34 views

### How to graph values versus time axis? [duplicate]

I'd like to use Excel 2010 to show on the x-axis when discrete events occurred and on the y-axis the magnitude of those individual spurious events. My goal is to try to visually analyse when different ...

**0**

votes

**1**answer

24 views

### Is there a software or web service that allows the creation of basic flow charts from text (such as a numbered or bulleted list)? [closed]

I know of many high quality flow charting tools, online and off, but is there any that allows the very rapid creation of a flow chart, however simple, from text? I want a way to bypass all the initial ...

**0**

votes

**1**answer

32 views

### Create a bar-chart from a date column plotting the number of occurances per month

Every time I fire up Excel I find myself thinking why the heck everything is so unclear to work with. From a PHP developers perspective I often find myself copying data to csv-files and process them ...

**0**

votes

**0**answers

20 views

### graphing the temperature curve of my wood fired oven in excel 2003 [duplicate]

I just finished building a wood fired bread/pizza oven. I have 3 thermocouples installed at 3 different depths in the 7" hearth mass. I have 2 installed in the dome mass. I also get readings on ...

**0**

votes

**2**answers

45 views

### Create Excel chart showing % change (multiple industries) over time

I'd like to create a chart that shows changes in percentage for several industries over a number of years, similar to this example:
I've attempted to arrange my data to make it easier to chart, ...

**0**

votes

**1**answer

83 views

### How to plot IP address frequency distribution chart on Excel or Calc?

I have one column of data:
IP Address
1.2.1.2
1.2.1.2
1.3.4.1
1.3.4.1
1.3.4.1
1.3.4.1
1.3.4.1
1.10.0.5
1.10.0.5
1.10.0.5
2.1.2.1
2.1.2.1
12.1.2.3
12.1.2.3
12.1.2.3
12.1.2.3
12.1.2.3
12.1.2.3
12.1.2.3
...

**3**

votes

**1**answer

128 views

### Excel - How to create a stacked radar chart?

I am trying to create a stacked radar chart in Excel similar to this:
.
I have to fill color in the space between the red and blue lines. I have tried every which way I can think of but to no ...

**0**

votes

**1**answer

32 views

### How do I insert another segment into the radar pie chart that is shown on this site?

I came across this tutorial for creating a radar pie chart, and let me say it is fantastic! The problem I'm having is that I need the chart to contain 10 or even 12 segments, but I cannot figure out ...

**0**

votes

**1**answer

181 views

### How do you plot time on the X axis in excel?

I need to plot the decay of my phone's battery against time over night. My starting time is 23:17:47 and my ending one is 07:05:49. I don't have any issue in changing the time format in the current ...

**-4**

votes

**1**answer

82 views

### Consolidate Text Data in Excel

I have an Excel document containing exam results. The results are in one column and appear as Pass or Fail.
I want to know percent of candidates who passed.

**0**

votes

**0**answers

36 views

### Create a pie chart from amount/category pairs

From a table like
Amount | Category
2 A
1 B
5 A
how to create a pie chart with one sector per category found in the second colum and the summed up values for each ...

**0**

votes

**1**answer

34 views

### Placement of Secondary Horizontal Axis

On the primary horizontal axis I can go to Format Axis > Line Color and Style. There I can choose the color and style of the line that represents 0 on the primary vertical axis.
However, with the ...

**0**

votes

**0**answers

17 views

### Can Excel automatically create an x-axis range?

I'm doing a basic financial analysis with Excel. The gist of it is I have an input parameter (discount rate) plus a bunch of static data that gets fed into the =NPV(rate, x1...x_i) function. I would ...

**0**

votes

**1**answer

34 views

### Excel Scatterplot Graph

How would I put on set of data on the x axis and the other on the y in Excel?
Meaning suppose I had 5 people rate two different films on a scale of 10 and I organized my results like this:
Person ...

**0**

votes

**3**answers

36 views

### Excel pivot and chart - hiding field from the chart

Hi have this pivot table
the pivot table is basically as follows
Project1 - 01/01/2010 | some data
Project2 - 01/06/2010 | some data
Project3 - 01/05/2010 | some data
Project4 - 01/04/2010 | some ...