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

**3**

votes

**2**answers

102 views

### How to do up a excel hair chart?

I'm trying to do up a chart (on excel), the chart that I have in mind is somewhat similar to the attached picture.
Data:
X-axis: dates (weekly data)
Y-axis: interest rates
Doing this, I can ...

**0**

votes

**0**answers

30 views

### how to realize a distribution diagram (for nationalities) in crystal report

I have some database views provided by our campus management software. I have a list of matriculated students per study program (subset of faculty) with some default data (addresses, nationality, ...

**0**

votes

**1**answer

35 views

### Bar chart displaying too few days

I am trying to display a week-long step in a project. I am using the standard calendar. 8 hours per day, 40 hours per week, 31 days per month. Auto schedule. The "Days" column shows the correct number ...

**0**

votes

**0**answers

36 views

### Having trouble graphing big data in Excel (3500+ rows, 2 columns)

I really need with help this issue. I'm trying to show a relationship between two categories but the only problem is there's too much data!
Problem: Is there a relationship between X and Y?
X and Y ...

**4**

votes

**1**answer

240 views

### Add multiple series to a dynamic chart

I have a large amount of data stored in a table that is used to update about 8 charts (through named ranges). Each chart has the date and ID as the x-axis with a particular parameter being charted. ...

**0**

votes

**0**answers

32 views

### Excel 2013 Pivot Charts: will not display multiple series

I have a table of data that I copied into Excel 2013. It looks like the following:
City Month Category AvgCount
Houston, TX Jan 1 0.05
Houston, TX Jan ...

**0**

votes

**1**answer

110 views

### I cannot insert a bar chart in PowerPoint

In rerence to a previous post I too can no longer insert a chart into powerpoint. When I select chart type it allows me to click but then blinks at me and does nothing. My IT guys have looked into ...

**0**

votes

**0**answers

51 views

### Radar chart in excel - charting with intended “gap data”

I want to plot a radar chart that has cross-fire axis with text added labels at each axis. The data items to be placed between these axis points eg at 2pm, 4pm, 8pm, 10pm.
I am having difficulty ...

**1**

vote

**0**answers

18 views

### Extract numerical data from MS Word graph [duplicate]

I have a word document that includes chart objects linked to data held in unknown spreadsheets that cannot be accessed.
The charts are 'frozen', in the sense that they are displaying the data ...

**0**

votes

**1**answer

1k views

### how to combine multiple charts with same x-axis (stacking two charts) in Excel

I have 3 time series data with wildly different data ranges. I can show two of them using a primary and secondary y-axis but that does not work well with the third data series.
In Excel is it ...

**0**

votes

**1**answer

58 views

### How can I divide a drawing into a unequal size blocks using Paint.NET?

I have a magnificent set of hand drawn rune cards that I wish to scan into a runic encyclopedia of some sort. Each card is 100mm x 80mm, so I could fit 6 per A4 page to scan them. After a little edit, ...

**1**

vote

**1**answer

60 views

### Automatically updating graph that only picks out information per date

Basically what I need is a formula to look up a date in column A (yesterday), return data from Column K and M to create a graph. Column A can have 0-3 rows per day that need to go into the graph. I ...

**0**

votes

**1**answer

5k views

### How to tell Excel to plot one column on x axis and another column on vertical axis?

I intend to plot y=cos(cX) in Excel, where c is a constant produced in first cell of column C using RANDBETWEEN(-50,50). Column 'A' represents X values (from -100 to 123) and column B contains f(x) ...

**1**

vote

**0**answers

335 views

### Linear date axis in pivot tables

How do I format a PivotChart so that the horizontal axis is displayed in linear time?
See the PivotTable below as well as the source data (both excerpts).
If it is in fact not possible to ...

**2**

votes

**2**answers

120 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

28 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

529 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

**0**answers

259 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

**0**answers

79 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

**2**answers

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

**1**

vote

**1**answer

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

**1**

vote

**2**answers

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

**2**

votes

**1**answer

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

**0**

votes

**2**answers

2k 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

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

**1**

vote

**1**answer

28 views

### plotutils: `graph` creates empty plots

I'm trying to create simple plots using graph as described in this tutorial. However, even the most basic example:
echo 0 0 1 1 2 0 | graph -T png > plot.png
produces a perfectly white 570x570 ...

**1**

vote

**1**answer

3k 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

**2**answers

354 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

55 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

87 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

80 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

150 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

239 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

32 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

**0**answers

52 views

### Can splunk's timechart function be made to carry forward idle entries from previous days?

I responsible for an agent which uploads data to a server. The agents also tell the server how "in-sync" they are and that data is forwarded on to syslog in a way that splunk can consume. I've ...

**0**

votes

**1**answer

64 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

114 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

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

**1**

vote

**1**answer

214 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

163 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

542 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

525 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

49 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

1k 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

72 views

### Plotting difference between logged sent-time / acknowledgment-time in Excel 2011

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

198 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

266 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

176 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

81 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

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