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

learn more… | top users | synonyms (3)

2
votes
1answer
945 views

Constructing an annual cycle/radial diagram in PowerPoint

I would like to make a diagram like the below in PowerPoint, but I can't figure out how to draw the curved boxes (like the ones that say "Fishing" or "Trapping" in the chart). Diagram   &...
0
votes
2answers
249 views

Excel for Mac - chart with no interpolation of discontinuities?

I would like to draw a chart in Excel for Mac with no interpolation on discontinuities, like this: How can I do that?
1
vote
1answer
2k views

pivotslicer connected to multiple pivotcharts

Can I connect my pivotslicer to multiple pivotcharts, but on different category levels, so If for example I have a categorytree that goes: Department --> Section If I choose "Section A" Then I can ...
0
votes
1answer
765 views

Excel PivotChart count rows where not blank

I've started using Excel's PivotChart to analyze data about customer requests. All my customer requests is stored in a sheet, with columns like "City", "Inspectiondate" and "Quotedate". If there was ...
0
votes
1answer
256 views

Excel 2010 charts from ungrouped data

I have a sheet that contains lots of information about jobs in a company. One of the columns is "city". That column contains values as such Falun Borlänge Stockholm Uppsala Borlänge Stockholm ...
2
votes
1answer
5k views

How can I increase Excel's graph axis area?

This is what the x-axis of my graph currently looks like (Excel 2010): The dates are in the format YYYY-MM-DD, but as you can see month and date are chopped off. I tried resizing (the dots at the ...
0
votes
1answer
1k views

Creating multiple plot per level of factor (trillis graph) in excel

Is there way to automate the process to make graphs like the following (also known as trallis graph) in excel ? I know there are some R interface with Excel (some of them need to be purchased), but I ...
1
vote
1answer
33 views

How to efficiently analyze simulation results with various degrees of freedoms?

I have been doing a lot of application testing, trying different libraries, threading ratios, operation distributions, etc... I want to be able to quickly generate graphs from my run data. The data ...
0
votes
1answer
553 views

Getting more than 100 data points to only represent part of 100%

I am trying to graph stance phase of gait, which in only about 60% of the entire gait cycle (heel strike of one foot to heel strike of the same foot) But in the data out put there are 140 cells or ...
2
votes
3answers
79k views

XYZ 3D-chart in Excel

I have a table of data as follows: X Y Z N1 2 5 6 N2 2 7 8 N3 0 1 2 N4 0 4 5 N5 9 10 10 N6 4 9 9 N7 0 2 4 N8 0 7 8 N9 0 7 8 Now I would like to ...
1
vote
1answer
170 views

Combining two plot types in excel

I want to combine xyline plot with bar plot in excel. I created xyline plot and then added new series with a hope that I can chance the series 1 later. Step 1: But it turned to be not true, see the ...
1
vote
1answer
6k views

Adding 80% horizontal goal line to pivot chart

I have a curve pivot chart to which I'd like to add a goal line with a static 80% horizontal line. I've seen some people suggest that one could merely add a column with 60% to the dataset. My dataset ...
0
votes
2answers
18k views

Is it possible to create a broken X axis in Excel 2007?

I'm trying to find a solution to a problem that I have with my data. In my data series, I have Temp over Time plotted on a scatter graph in excel. The data plots a period of around a week in the ...
0
votes
1answer
85 views

Excel table / chart issue when updating the select data to a smaller amount

I believe I have a simple fix but cannot find the answer anywhere online. I have a table that looks something like: date / total1 / total2 / total3 mon / xxx / xxxx / xxxxx tue / xxx / ...
4
votes
1answer
2k views

Sample data to create Excel timeline

I am trying to create an Excel timeline like the one shown here. I am not understanding how the sample data would look and how to go about making this. Please post a screenshot or explain how to ...
2
votes
2answers
1k views

How to create an Excel chart showing a value and its change?

I would like to create a chart that shows a value and how it has changed, like this one in Excel. The importatnt thing (which I am not able to achive) is that there are two numers associated with ...
0
votes
1answer
350 views

Scatter diagrams with group labels for X/Y coordinates

I'M trying to create a map layout from an Excel spreadsheet in Excel 2003. I have x and y coordinates in columns as well as group name and place name. I tried using a scatter chart but I can only ...
1
vote
5answers
50k 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 ...
0
votes
0answers
68 views

Excel creating weird diagrams

I have a list of times in one column. They are formatted as Time cells. When I simply select the values and click Insert -> Line (diagram), I can't seem to get the right kind of diagram. What ...
0
votes
1answer
4k 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 ...
3
votes
2answers
4k views

How can I format data bars based on value in Excel 2010?

I have a dataset containing values from 0 to 584. I would like to illustrate this using data bars, but I would like the databars to be green when the number is greater than 150, and red when the ...
1
vote
1answer
4k views

Time units and automatic formatting of the y-axis in Excel

I have a chart with time values on the vertical (Y) axis. As the values can change a lot the formatting of the axis minor and major units is automatic. The problem is that Excel chooses values which ...
1
vote
2answers
689 views

How do I disable screen updating while reformatting an Excel 2007 chart?

I have a chart with about 70,000 data points. When I format the axes or data series, Excel automatically updates the chart before I am finished editing the value. This is very slow (1+ minutes), even ...
0
votes
0answers
86 views

Place multiple columns onto one line [duplicate]

Let's say I have a table in a spreadsheet that works like a calendar: Jan Fev Mar ... 1 5 7 1 2 3 4 9 3 8 3 1 4 2 9 0 5 2 1 2 ... And so on... I need to make a chart ...
1
vote
1answer
509 views

Label's format in barchart different from the corresponding cell

I have stacked bar chart. In the label's format I checked "linked to source". Now in the datacell,l I have this custom format "[>999999]#.##0,00.." M$";[>999]#.##0,00." k$";#0,00$". The problem is ...
8
votes
1answer
32k views

Plot date and time of an occurrence

I need to plot (over a period of day measurements) date of occurrence and time. An example is "we are tracking Billy's occurrences of aggression, date and time of the event". How can I show this?
0
votes
1answer
44 views

Blank Excel PivotChart

My Pivot Table has everything I want however,I want my chart to show how many Issues have the status of severe, mild, or moderate. But instead it is blank. What should I do?
2
votes
1answer
222 views

Create pie chart with single sector separated from the rest?

Is it possible to use LibreOffice (I'm currently using 3.5.4) to create a pie chart where a single sector of the chart appears removed from the rest? If so, how to do it? Alternatively, can someone ...
2
votes
1answer
821 views

excel chart dynamic range based on values

I'm trying to create a chart that auto updates itself from a data provided. The range of the chart is always fixed/locked. The issue I'm facing is that when a value for a certain month is 0, I want it ...
2
votes
1answer
743 views

Graph with uneven spacing in excel

I need to make a graph of follow-up data at 0, 6, 12, and 24 months. Excel for Mac 2008 puts the 24 months at the 18 month position. How do I get the correct spacing without including 18 months?
0
votes
1answer
38k views

Can I add a single point to a graph in excel

In Excel 2010, how do I graph a specific point on a graph that already has a line graphed on it. This specific point is from a different data set and does not fall on the line.
0
votes
1answer
619 views

Creating a pie-chart (of how many times a number is repeated) in Excel

I am trying to create a pie chart in Excel, but cannot figure out how to get it to work. I have a list (column) of numbers and the pie-chart needs to show how many times numbers are repeated (or how ...
0
votes
2answers
3k views

How do I create a chart in Excel with dynamic series based on the data content?

How would I define a chart in Excel (2010) that shows a time series graph containing various series based on the data content itself? For example, here is a data set: Date Series A Values ...
10
votes
2answers
499 views

How to turn a 3D chart into something watchable on a 3D television?

Let's say I have a 3D scatter plot in R or a data frame with 3 fields filled with numeric data. How can that be "turned" into "something" watchable on a 3D television (like a random big screen TV ...
1
vote
1answer
3k views

Lines over data in Excel 2007 Scatter Graph

I have some data that needs plotting in a scatter graph in Excel 2007. However, I need another line (for some arbitrary function - e.g. using trendline will not work) that is represented by a second ...
1
vote
2answers
95 views

Excel: How is this graph even possible?

I made a line graph using two sets of data: However, the blue line is totally out of place somehow and I have no idea why. I feel like I've checked everything. What could be going wrong?
0
votes
3answers
2k views

Putting a line feed in a string built in an excel formula in a data label

I need to construct a data label in an excel chart using a formula building the string from two cells with a line break between them. This would work in a cell formula: =A1 & CHAR(10) & B1 ...
0
votes
1answer
227 views

Excel X axis label

In Excel, I want the value of the data marker displayed at the right edge of the data marker. Ex: an amount representing 0-10 is graphed, and the 10 on the X axis is on the right edge of the column ...
4
votes
1answer
1k views

How to make a LibreOffice Calc XY (scatter) plot with named dots?

I have a simple XY scatter plot made from a 2-column spreadsheet. When I hover over a dot, I can see the ID of the dot (e.g. "Data point 8456"). I would like to know if I could have the content of a ...
1
vote
1answer
554 views

Excel 2007: plot data points not on an axis/ force linear x-incrementation without altering integrity of non-linear data

In Excel, how does one go about plotting points that don't have an x component that is an x-axis label? For example, in my graph, the x-components are derived from the cosine function and aren't ...
2
votes
2answers
435 views

Manually “draw” data for chart, output to CSV

I need a service that will allow me to draw a chart line by hand and generate data points for what I drew. This might sound crazy, but I need some data (preferably in CSV output) that will only ...
3
votes
3answers
30k views

How to rotate text in axis category labels of Pivot Chart in Excel 2007?

I'm using a pivot chart in Excel to display data. My problem is: I can not influence the orientation of the text in the "axis" (don't know how to call it correctly, I'm sorry). As an example: In the ...
0
votes
1answer
1k views

Pull Data from Pivot Table to Grid on Different Worksheet

I am trying to make an Excel Workbook that contains the statistics of an XBox Tournament that our office is doing. Winner of the whole Tournament wins the XBox! It's fairly simple rules. Everyone will ...
1
vote
1answer
979 views

Linked Excel 2010 Charts Won't Show Field Codes in Word 2010 - What am I doing wrong?

Thank you for reading. I hope this is something simple I am overlooking. Synopsis: I have a Word doc containing linked charts from a single Excel source. They are docx and xlsx files created in Word ...
1
vote
2answers
1k views

Excel 2010 column graph round percentage values to over than 100%

I have a graph showing percentages with a Data Table alongside. Excel 2010 rounds the values so that columns can sum to more than 100%, but I want every column in the graph to total exactly 100%. ...
1
vote
2answers
3k views

Creating a graph with a “peak” value (x-axis from 0 to 100 to 0)

I want to create a graph whose x-axis will start from 0, peak at 100, and then return to 0 - all from left to right. An example is attached. How do I do this? Data: Applied Voltage Capacitance 1....
1
vote
2answers
2k views

How to plot 3D graphs in Excel from CSV data?

I have data formatted like this in a csv file: a, 1, 4, 6.0 a, 2, 42, 16.0 a, 5, 14, 69.3 a, 11, 4, 7.0 b, 1, 45, 6.0 b, 2, 45, 1.9 b, 9, 2, 4.4 b, 11, 4, 7.9 lines with first parameter a is one ...
0
votes
1answer
372 views

How to get average of multiple time series

I have few computers running. I want to get the average CPU usage of these computers and plot it as a graph. So I've collected CPU usage in regular intervals in these machines. So for each computer I ...
-1
votes
2answers
112 views

Microsoft Excel not graphing

Im not sure if this is a math question or a su question. The experiment was relating the period of one "bounce" when you hang a weight on a spring and let it bounce. I have this data, one being mass ...
1
vote
1answer
2k views

Ascii-art graphs in Linux

I have a text file that represents the runtime of a specific script, with each line representing one run: 141 124 156 204 498 512 444 374 189 120 143 132 One can see that the section that I pointed ...