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

**1**

vote

**1**answer

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

**1**

vote

**1**answer

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

**1**

vote

**1**answer

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

**3**answers

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

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

**1**

vote

**1**answer

5k views

### Excel chart axis does not depict the data correctly

I have a problem with an Excel chart.
I have
a primary axis (two series), showing volumes in millions
a secondary axis showing percentages (one series)
The primary axis seems to be adding the ...

**1**

vote

**1**answer

973 views

### Record CPU usage then create Excel line chart with “Series” Column

I need to create a line chart to display the cpu usage of each process over time. How do I create the chart with time as the X axis, %CPU as the Y axis, then use the command name to indicate which ...

**1**

vote

**1**answer

259 views

### Advanced graph in Excel

This is my data:
Date Electricity Electricity2 Electricity3 Water Oil level (cm)
2011-06-30 8508 16041 7521 794 /
2011-07-10 8568 16170 7601 800 ...

**1**

vote

**1**answer

3k views

### Creating a 2D chart in excel with 2 Y-axes - one stacked, one non-stacked

I'm looking to create a 2D line-chart in Excel 2007.
It will have 2 Y-axes. The X axis will be dates.
There will be 5 series. I want 3 of the series to be stacked and use
one Y-axis, and the ...

**1**

vote

**1**answer

4k views

### How do I create a line graph which ignores zero values?

I want to create a graph showing trends over time, calculated from a formula of various data.
However, some data is missing, resulting in zeroes in the calculated data which the chart uses.
When ...

**1**

vote

**2**answers

2k views

### Splitting data into multiple series' in Excel Graph

I have data from a csv formatted as such:
StartTime EndTime Duration Type
--------- ------- -------- ----
43:04.7 43:06.9 2200 long
43:06.9 43:08.7 1825 middle
43:08.7 ...

**1**

vote

**1**answer

1k views

### Math Round multiple cells, generate integers and histogram integer values

I want your help for the following points:
How generate integer values using Data menu > Data Analysis > Random Number Generation
or (if this action can't be done)
how round multiple cells in same ...

**1**

vote

**2**answers

3k views

### Excel: How to create a chart that automatically scales the axis

I have 2 columns with values, say A and B which values I want to use as X and Y axes values correspondingly.
The values are the following:
A: 412 684 944 2009 9601
B: 7813,4 10377,6 11138,8 16216 ...

**1**

vote

**1**answer

821 views

### Excel Chart not displaying X Axis

I've got a chart in a spreadsheet in Excel 2010 which is using A chart = "Stacked Column in 3-D"
I have defined the Horizontal (Category) Axis Label in the Select Data Source window and it is ...

**1**

vote

**2**answers

427 views

### Grapher: Edit Equations Without GUI

I'm trying to edit the equation of a Grapher file without opening the Grapher UI.
I've gotten as far as knowing that I need a hex editor to do this. I can't, however, find my equation in that file to ...

**1**

vote

**2**answers

8k views

### Excel - Chart that sums the values in multiple rows for each series

Suppose I have a spread sheet that looks something like this...
Now, I'd like to create a column chart that has 3 series, one for each country. Then, I want series for each category, but I want to ...

**1**

vote

**2**answers

2k views

### Excel 2010, Consolidating Category Axis in Pie Chart

I am working on a very basic "home budget" spreadsheet, to quickly see: A) how much money is left after the bills are paid and B) what % of withdrawals are going to what categories of expenses.
I ...

**1**

vote

**2**answers

1k views

### Excel charts in PowerPoint 2007 are not editable by PowerPoint 2003

I'm trying to save a PowerPoint 2007 presentation which includes a chart copied from an Excel 2007 sheet in 97-2003 format but the chart is no longer editable by Office 2003 since it's automatically ...

**1**

vote

**1**answer

56 views

### low-latency charting?

Need to deliver real-time charts (mostly bar and line charts) and wondering if a fast library can help.
I guess that C is mandatory for speed and I would favor frame-buffer drawing (rather than a ...

**1**

vote

**2**answers

10k views

### Excel bar chart - how to make axis as time scale

My data has column 1 = date (date format), column 2 = quantity (number format). The data looks like:
date qty
1/3/2010 5
2/3/2010 2
2/4/2010 3
2/9/2010 1
4/13/2010 5
5/31/2010 5
...

**1**

vote

**2**answers

851 views

### How to get scrolling plot in Linux (using command-line tools)?

Supposing I have a program that prints lines with data periodically, how can I turn then info them into graphical plot that updates itself each time new line available?
$ ./prog
10 44
20 66
30 55
40 ...

**1**

vote

**2**answers

7k views

### Why can't I add a trendline to a chart in Excel 2007?

I created a really simple chart based on 2 columns (date and numeric value).
I click on the chart, go to Chart Tools/Layout. The Trendline drop down is greyed out.
What am I missing?

**1**

vote

**2**answers

59 views

### Is there a web site that allows you to draw an ascii chart with boxes and arrows easily?

Ascii drawings and charts are a useful way of documenting software and can be included directly in source files near the code they document.
I'm looking for an online tool to draw them and be able to ...

**1**

vote

**2**answers

5k views

### How can I create a pie-chart with gnuplot?

I want to create a pie-chart. Is that possible with gnuplot and how to realize that?

**1**

vote

**1**answer

165 views

### How to use Excel 2010 VBA to set series line color, marker fill, and marker line color

I am trying to write an Excel 2010 VBA subroutine to format charts according to a predefined (i.e., defined by me) standard. The particular attributes that I want to be able to set are merely the ...

**1**

vote

**1**answer

49 views

### Using Chart BeforeDoubleClick with a chart object in worksheet

I am trying to get a macro to work on a chart in a worksheet using the Chart.BeforeDoubleClick event.
I have been able to use BeforeDoubleClick event (without the use of class modules) in a ...

**1**

vote

**1**answer

52 views

### How to leave out certain rows in input data when creating a line chart [closed]

I created a line chart in Excel and manipulated the chart data that is attached to it; however, I have some rows of my chart data that I do not want displayed on the line chart. How can I make these ...

**1**

vote

**1**answer

33 views

### Can I produce an area chart specifying x and y coordinates

I'm trying to make an area chart in Excel in which I can specify not only the Y coordinates of each point in the series, but the x coordinate also, but it seems to not want me to specify anything like ...

**1**

vote

**2**answers

286 views

### How to highlight calendar cells based on given start and end date

For a while now, a coworker has been using a chart similar to the one shown below and wants to automate it (i've already added the days before/after due date).
The chart is printed or worked on at ...

**1**

vote

**1**answer

53 views

### Given multiple start dates, how to assign counts to relative date values?

I'm trying to create a before-and-after graph in Excel, lining up multiple milestone dates at month zero, and assigning relative month numbers to months prior and subsequent to milestone month.
My ...

**1**

vote

**1**answer

26 views

### Office 2010 on Mac OS 10.8: Drawing a Chart

I have a simple data set and I want to make a graph for it.
Years Upper Band Lower Band
2010 0.73 0.63
2020 1.04 0.83
2030 1.36 1.06
2040 1.74 1.31
2050 ...

**1**

vote

**1**answer

244 views

### How to plot complex data as a radar chart in MS Excel?

I have some data from an experiment (which I did not design) that I'm supposed to analyze. After looking through the possible options for displaying the data to visually analyze, I believe that a ...

**1**

vote

**2**answers

6k views

### Excel: How to Superimpose 2 Stacked Column Charts

I have two stacked column charts (with no gaps between the columns) that have identical X- and Y-axes with same intervals. One graph is displayed in red, while the other graph is displayed in blue. ...

**1**

vote

**1**answer

35 views

### Using exported Google Play statistics in Excel

I have exported data from Google Play statistics, but I got this:
date,total_user_installs
20140618,291
20140617,291
20140616,291
20140615,290
20140614,289
20140613,289
20140612,288
20140611,286
...
...

**1**

vote

**1**answer

292 views

### Display numbers twice on x axis in excel chart

I have following values that I would like to display on the X axis of my chart:
0,1,2,3,4,5,6,7,8,9,10,10,10,9,8,7,6,5,4,3,2,1,0
But my chart is displaying the values as ...

**1**

vote

**2**answers

66 views

### Excel plot digitizer [closed]

Is there any plot digitizer usable in Excel? I have discrete points (values X and Y) and I have to create graph from these - Excel can create the "mean curve" (I am sorry, I am not a native speaker so ...

**1**

vote

**2**answers

92 views

### How can I use the row number in an Excel chart?

I have an Excel table which is simply one column of dates. Each date has a distinct value, and they are already sorted. Something like:
5/29/2011
6/21/2011
6/26/2011
7/1/2011
7/3/2011
...

**1**

vote

**1**answer

708 views

### Changing the units on the x-axis in a LibreOffice Calc chart

I've used the LibreOffice chart wizard to make a chart, and I would like the x-values to be different to the default of 1,2,3... (in this case, 500,1000,...). How can I do this?

**1**

vote

**2**answers

645 views

### In Visio, how do I create a chart with coordinates throughtout time

I have these data (from MSSQL, that I converted into Access/Excel) on a moving object in a defined space
x y time
0 0 07/04/2014 08:48:07
5 5 07/04/2014 16:35:25
6 4 ...

**1**

vote

**1**answer

168 views

### Two problems with Excel graphing

See the following figure
I have two problems with Excel 2013, I am not sure how to solve these:
1) The axis title overlaps the data values on all my axes. From the figure, I am unable to change ...

**1**

vote

**1**answer

1k views

### Excel custom axis label

I'm having troubles with some charts I'm creating using Excel. Some of the values I'm plotting are too big (264) to be labeled in the axis. Due to this, Excel automatically puts them in scientific ...

**1**

vote

**1**answer

534 views

### Chart Categories: How To Combine X-Axis Categories

The Task
I'm putting together a dashboard wherein I'm building several charts. I've attempted to use a pivot chart (2D line chart) to pull data from two different pivots (with the same source data). ...

**1**

vote

**1**answer

831 views

### Grouping Excel charts in a Word document

I have some Excel charts that I've pasted into Word, and I would like to group them together so they move as a unit as I'm moving text around.
Currently, they look like this:
(forgive the rough ...

**1**

vote

**2**answers

275 views

### Average using Elapsed Time processing a number of docs

I process documents and want to get a formula showing the average time to process each document.
Here's my data:
number of docs processed (column G)
start date/time (H)
end date/time (I)
elapsed ...

**1**

vote

**1**answer

1k views

### Excel error bars based not on the graph data, but a separate set of error measurement data

I have several data sets, each of which includes several tests. Each test contains several temperature samples at different locations. For each data set, I have an average of the different tests for ...

**1**

vote

**3**answers

7k views

### Plot cumulative data in Excel

Is it possible to plot data in excel without having to define the function of the data in an extra column?
Think of this simplified example:
There are two columns with numbers A and B. Is it ...

**1**

vote

**1**answer

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

**1**

vote

**1**answer

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

**1**

vote

**1**answer

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

**1**answer

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