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

learn more… | top users | synonyms (3)

1
vote
1answer
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
1answer
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
2answers
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
2answers
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
2answers
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
2answers
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
1answer
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
2answers
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
2answers
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
2answers
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
2answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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 ...