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

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

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

226 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

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

**0**

votes

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

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

283 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

586 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

363 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

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

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

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

**2**

votes

**3**answers

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

179 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

79 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

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

326 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

383 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

884 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

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

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

**1**

vote

**3**answers

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

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

187 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

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

795 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

**3**answers

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

**1**

vote

**3**answers

5k views

### Real-time graphing application for SQL data

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

**1**

vote

**0**answers

537 views

### Excel chart axis values are doubling up along the axis

Excel chart axis values are doubling up along the axis - how do I stop this happening? It is in both the primary and secondary scales. eg the axis shows 18, 20, 20, 22, 22, 24, 24, 25

**0**

votes

**1**answer

342 views

### Excel Different line graph loaded on each selection

I have been adding a lot of absence/presence data into an MS Excel 2011 for Mac sheet. On the days students are present they get points, on days they are absent they get zero. If student was there, ...

**0**

votes

**0**answers

71 views

### Programs for reading data off interactive web charts

This question is in the same vein as this one: Program for reading data off scanned graphs
Recently more and more interactive charts show up on the Net. Have a look at the following one:
...

**0**

votes

**1**answer

384 views

### Excel per-point custom error bars

I am attempting to draw error bars on a multiple bar graph in Excel 2007, and I am having trouble with the custom error bar minimum value. First, I created the graph from multiple series, then I ...

**0**

votes

**1**answer

1k views

### X axis on Time-Based data

I have a series of 24 hr. data, taken about once per hour. I wish to plot the values against time. On day 1 the 10:00 data was taken at 10:10, on day 2 the data was taken at 9:58. I do not want both ...

**2**

votes

**2**answers

36k views

### Easily Plotting Multiple Data Series in Excel

I really need help figuring out how to speed up graphing multiple series on a graph. I have seperate devices that give monthly readings for several variables like pressure, temperature, and salinity. ...

**1**

vote

**2**answers

4k views

### Change the Point Color in chart excel VBA

I'm trying to the get the points from a chart in excel vba? I made a chart of student marks in excel, and I want to put a condition i.e if marks on chart are greater then 90 then the point color ...

**0**

votes

**2**answers

669 views

### Date axis with a partial year

I have a line chart with data spanning from February 2002 to today. At the moment, the date axis looks like this:
Is there a way to have the first date be Feb-02 (no change), but the next one be ...

**2**

votes

**3**answers

266 views

### What tool to use to create a chart like this one? [closed]

Which tool can you recommend to draw such a diagram:
I have tried Excel, but it is not really straight forward.

**-1**

votes

**1**answer

73 views

### Is there a tool to get data from a pie chart instead of the other way around?

I'm looking for a tool that helps me creating an investment portfolio. I'd like to decide the percentages first, and then the tool would output quantities. Also, percentages should be hierarchical. ...

**0**

votes

**2**answers

173 views

### Create Excel pie chart from choice placement

I have a table like the following :
Choice 1 Choice 2 Choice 3
Person A 3 2 1
Person B 1 2 3
...

**3**

votes

**2**answers

5k views

### How can I plot a grouped histogram with LibreOffice Calc?

I would like to produce a grouped categorical histogram with LibreOffice Calc.
With grouped I mean an histogram with N columns instead of a single one for each category.
Something like this:
Any ...

**0**

votes

**1**answer

202 views

### Formula in Excel graph

I am creating a line graph in Excel 2007. What I would like to achieve is to specify a formula in the chart data range.
What I have now in the chart data range is:
...

**1**

vote

**2**answers

662 views

### Looking for PHP memory/CPU graph generator [closed]

Basically, that's what I'm looking for. I want an app that makes a live graph of the server's CPU and RAM usage. Is there anything like this?

**1**

vote

**1**answer

1k views

### Excel - set data range for multiple charts

I have a 'dashboard' of weekly stats - with week numbers in the columns across the top, and about 70 metrics in the rows.
I want to create around 20 charts from these different metrics, but always ...

**4**

votes

**0**answers

654 views

### Create line graph with embedded horizontal histogram

How do I create these kinds of graphs:
with the horizontal histogram counting the number of times the left graphs go through a certain range?
I have access to Microsoft Excel and R.

**1**

vote

**4**answers

4k views

### Good (preferably free), easy to use, attractive flowchart software [closed]

While there is no shortage of awesome concept mapping or mindmapping software, I'm left rather cold by the offerings of flowchart related software or apps available.
I'm looking for something that ...

**0**

votes

**1**answer

790 views

### Windows. Active X objects. Excel Chart

i need to find Excel active X object mschart.ocx or mschrt20.ocx.
Where are they laying?
Thanks!
P.S:
Am i right, that they can help me to use active x chart: msdn
Thanks!

**1**

vote

**1**answer

1k views

### Organization chart using Active Directory

Is there any tool which can depict Organization chart using data pulled from Active Directory.
I am looking for portable thick client which can run on Windows.