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

**0**

votes

**1**answer

43 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

**1**answer

217 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

**1**answer

800 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

**1**answer

699 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

**1**answer

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

**1**answer

589 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

**2**answers

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

**2**answers

494 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

**1**answer

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

**2**answers

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

**3**answers

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

**1**answer

225 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

**1**answer

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

**1**answer

553 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

**2**answers

421 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

**3**answers

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

**1**answer

948 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

**1**answer

963 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

**2**answers

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

**2**answers

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**

vote

**2**answers

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

**1**answer

357 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

**2**answers

111 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

**1**answer

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

**3**

votes

**3**answers

18k views

### Excel chart show year intervals on axis

ON the x-axis of a chart in Excel I would like to show the separates when years change and put the year in the middle of the interval.
How can I do that?
See the below image for an example of what I ...

**0**

votes

**1**answer

369 views

### How do I select a blocked chart in a Excel 2010 chart?

How can I select a blocked or protected chart in Excel 2010?
When I right-click on the chart, the cursor changes to a circle with a diagonal line within it - a "blocked" sign. I'm doing a study ...

**0**

votes

**1**answer

683 views

### Making chart from custom data format in Excel 2010

I am defining custom data format via Apache POI. I know I need to use following construction:
DataFormat data = this.workbook.createDataFormat();
...

**2**

votes

**1**answer

460 views

### Why am I unable to use a named range beginning with “Corona” in Excel charts?

I'm running into a ridiculous problem in Excel 2010 where I cannot seem to use a named range whose name begins with "Corona" in a chart. I've created a new workbook with a simplified version of the ...

**3**

votes

**1**answer

34k views

### How to create dynamic Scatter Plot/Matrix with labels and categories on both axis in Excel 2010?

Let us consider a following data set:
Name | Age | Hair Color
-----------------------------
John | Young | Brown
Sophie | Old | Blond
Adam | Mature| Blond
Mark | Teen | Dark
Jeremy | ...

**2**

votes

**3**answers

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

278 views

### What is the best way to graph this in excel

I have a table in excel with three columns:
Name
Start Date
End Date
I want to create a chart with count on the left hand side and date on the bottom to show the count of open item (defines ...

**3**

votes

**3**answers

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

190 views

### Excel Line chart multiple related series, colouring

I'm using MS Excel 2010.
I have a worksheet that looks like this
---/ 1001 / 1002 / 1003 / 1101 / 1102 / 1201 / 1202 / 1203 / 1204
R2 / ...
R3 / ...
...
I would like to create a line chart with ...

**0**

votes

**0**answers

82 views

### Excel 2010, changing on its own

Excel 2010 has began changing my chart tab names from the ones that I set, back to "chart 1" "chart 2", etc.
I went through and changed them all to what I had set again, and the next day they were ...

**2**

votes

**3**answers

19k 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 ...

**0**

votes

**1**answer

1k views

### How to make LibreOffice Calc to connect points in a holed series chart with lines?

I've got a time series data table with one function (row) value available for every month and the second for every 3rd month (every quarter), having holes (empty cell values) for every 2nd and 1st ...

**0**

votes

**2**answers

3k views

### How to create a scatter chart?

I select "Scatter" get the empty chart, RMB inside the chart, and click "Select Data". Up pops "Select Data Source", with entry elements "Chart data range", "Legend Entries (Series)", and "Horizontal ...

**3**

votes

**1**answer

365 views

### Use of Excel 2011 to produce a line graph showing amplitude variations with distance

I have 2 columns of numbers:
Column A I want to be the X axis of a smooth line graph which goes through all of the data points which shows distance.
Column B I want to be the Y axis showing ...

**1**

vote

**1**answer

418 views

### Excel - Create the same Charts Monthly

I've got a workbook with a table that has the months across the top. Each month, another month column will be added and the data for that month will be filled in.
For each month, I want to create ...

**3**

votes

**1**answer

1k views

### Print an organizational chart to PDF from JSON data?

I've been searching for a few days and haven't found quite what I need yet.
I've got a tool I'm working on that displays a person in a sort of visual hierarchy of the company (from the CEO down the ...

**1**

vote

**1**answer

3k views

### How to create excel line charts with irregular scales

I am trying to create a line graph, The vertical axis is an irregular scale - 1,1c,1b,1a,2,2c,2b,2a and so on.
Here is the data in chart format
I am having trouble representing this data in the ...

**1**

vote

**2**answers

1k views

### All cells in column as graph source except header

I want to create a graph of all values in a column, except the first which is a header. I could do this by selecting the following as Series X Values:
=Foo!$A$2:$A$8
Problem is that I'd have to ...

**2**

votes

**3**answers

17k views

### Creating a chart using a dynamic named range in Excel 2010

I am trying to create a scatter plot in Excel 2010 using dynamic named ranges and am having trouble getting it to work. Here's simple example that is failing:
Open Excel, starting a new workbook
...

**0**

votes

**2**answers

5k views

### Excel Line Graph with columns and rows transposed

My team has a spreadsheet in which we track counts of incidents of known issues from week to week. The sheet is organized with the issue title in column A and "Week 1" through "Week [N]" in columns B ...

**2**

votes

**1**answer

209 views

### Custom area graph in Excel (or google spreadsheet)

I am trying to visualize my loans with area graph and have some additional needs/wishes.
For example - this is my data (made up):
house car mower vacation
diners ...

**2**

votes

**2**answers

7k views

### Excel graph - two lines, one axis with date

I want to make Excel chart that shows my accounts' balances in time.
I have 2 bank accounts and I have all transactions saved in Excel. The data's format is:
Column A Column B Column C Column ...

**1**

vote

**1**answer

899 views

### How can I break external links in PowerPoint 2007 but keep the charts editable (not images)?

I have created a few charts in an Excel file and then pasted them as links into PowerPoint (PPT). Whenever I update the excel file, PPT updates automatically.
However when I break the links, the ...

**1**

vote

**4**answers

13k views

### How do I get a chart in Excel to add new data series automatically?

I am working on some charts for financial reporting. One of them shows some values for individual companies.
I will need to add new companies on a monthly basis, and would like the diagram to ...

**0**

votes

**1**answer

754 views

### Is it possible using Matlab to draw a trading graph with deals?

In my trading software I write myself logs like this:
634782126998342815 q 0.0156327559515302
634782126998966816 q 0.0156323845819952
634782126999122816 q 0.0156323423136646
634782126999278816 q ...

**1**

vote

**3**answers

9k views

### Real-time graphing application for SQL data [closed]

I am looking for a free data graphing application that can pull data from MySQL and display it on a trend graph without any programming. It should use a GUI to select the data to be plotted, start ...