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

learn more… | top users | synonyms (3)

-1
votes
1answer
5k views

Convert a line graph into data [duplicate]

Am looking for a tool that will import a line graph (chart) image and convert the line into numerical data, either in a spreadsheet or a database. For example, given an image like this: It might ...
0
votes
1answer
1k views

Excel coloured line chart for grouped data?

In Excel how do I create a line Chart with each simulator being its own coloured line showing Calculation time (and potentially another colour for its Total time). Axis X = Rounds Axix Y = Time ...
2
votes
0answers
147 views

Excel 2010 / Outlook 2010 - Changing the size(with precise numbers) of a chart exported from Excel to Outlook?

If I export(copy&paste) charts from Excel 2010 to Outlook 2010, I'm not presented with a "size proprieties" option when trying to resize them. Since I have multiple chart to resize for each ...
4
votes
1answer
48k views

How can I hide 0-value data labels in an Excel Chart?

I would like to hide data labels on a chart that have 0 as a value, in an efficient way. I know this can be done manually by clicking on every single label but this is tedious when dealing with big ...
2
votes
2answers
293 views

Plotting timedata in gnuplot

I have a log file (auth.log) where non-relevant lines has been removed. I wish to aggregate lines per hour/day into the plot, meaning that each line that is within the same hour or day is aggregated ...
0
votes
2answers
333 views

Why is my pivot chart not saving properly in Access 2010?

Working in Access 2010 and am trying to build a pivot chart from a query. My query is looking at an item type (multiple possible) and closure date with the intention of creating a stacked bar chart. ...
-2
votes
0answers
106 views

Get series values on condiation, excel [closed]

I have following data in my XLS - 8:35:01 NZLOAD app read: 2000005 01:03.0 8:35:03 Pending app INSERT 0 00:00.8 8:35:14 T4 app INSERT 1944132 00:09.6 8:35:47 NZLOAD app read: 2000005 ...
1
vote
0answers
254 views

LO Calc: Why are data labels placement options greyed out?

When creating pie charts I like to add the values of the individual slices to the chart. LO Calc allows you to do this ('Add data labels') By default Calc places these values in the center of the ...
2
votes
1answer
13k views

A sensible way combine two stacked bar charts in Excel?

I have one chart that has several stacked bars with identical components - one for each category. Each of the components of those bars can also be represented with a stacked bar chart, like the ...
1
vote
3answers
48k views

Scatter chart, with one text (non-numerical) axis

Lets imagine I manage 100 pizza stores. I want to plot a chart each day, of how long deliveries are taking. My data might look like this: London 23 London 22 London 44 London 18 ...
2
votes
2answers
7k views

Excel Scatter Chart with category based formatting of points

I have some data which I would like to plot in the scatter chart in the following format date, category, value 01-Jan,Cat1,0.03 01-Jan,Cat2,0.13 01-Jan,Cat3,0.27 01-Jan,Cat4,0.32 ...
0
votes
0answers
394 views

Excel VBA updating graph data

I have several charts referencing off one particular dataset. Each chart has a different number of series. Each series refer to one particular row of the dataset for a certain number of columns (ie. ...
4
votes
2answers
8k views

How to make a chart that graphs frequency of entries?

I have an Excel workbook that has nothing but dates (sorted), in the following manner: 11/14/2011 11:53 10/14/2012 11:53 11/23/2012 19:28 12/24/2012 12:27 ... 12/1/2013 11:48 I would like to create ...
0
votes
2answers
118 views

Embed Excel Charts into Powerpoint Issue

I am currently experiencing an issue with powerpoint 2010. I have created a three part chart in Excel and am trying to export it to powerpoint. However whenever I try to paste special the excel as an ...
0
votes
1answer
148 views

Calculating Range coverage

I'm putting together a sheet that includes two data columns, 'Min Value' and 'Max Value'. All values between Min and Max values are consider the 'Range' of each entry. The goal of the sheet is to ...
2
votes
1answer
567 views

Highlight specific points on a surface chart in excel

I was wondering if its possible to highlight a series of x,y,z points on a surface chart in excel, similar to what ive done manually in the picture.
0
votes
1answer
2k views

How can I graph survey results in Excel?

I would like to graph my survey results with the numerical values of the responses listed on the vertical axis and the questions listed on the horizontal axis. For example, I imagine the questions ...
1
vote
1answer
1k views

Create a excel chart only with axis

I want to create an excel chart with only the axes namely x axis and y axis with x axis values ranging from 1 to 100 and y axis values ranging from 1 to 100 Is this possible? If so how to do it? ...
0
votes
1answer
135 views

excel chart: how to change data points format in part of the curve?

Suppose I have a curve of x(t), data points are shown as blue squres. Is it possible to easily set it, so that when x(t) is less than 0, the point will be shown as red circle? I know each data point ...
1
vote
1answer
554 views

Expanding set of y axis values in chart, developed by MS-excel?

I have developed a chart from a set of values of excel file, Now what I have to do that I have to expand the y axis values from point 5 to point 8, Can anyone please suggest me that how to do that. I ...
0
votes
1answer
1k views

Scatterplot with variable X on X axis and Y on Y axis

I have a dataset with variable A (Age) and B (performance). I want to create a scatterplot with variable A on the X axis and B on the Y axis, but Excel is acting all weird with it. I have approx 120 ...
4
votes
1answer
29k views

Excel generate and format horizontal error bars

I have been trying to generate and format horizontal and vertical error bars in Excel 2010, and there is no problem with the vertical ones, but I cannot figure out how to manage horizontal error bars. ...
2
votes
1answer
2k 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 ...
0
votes
1answer
4k views

ActiveSheet.ChartObjects(“chart”) always returns Nothing?

I'm querying for a chart in the worksheet and I can see it's there but everytime I execute the following piece of code it evaluates to 'Nothing'. Why is that? Sub DeleteGraph() Dim graph As ...
0
votes
1answer
14k views

How to show an additional single point on a line graph in Excel?

I have a data set which shows the "efficient frontier" curve and a data point showing the decision made. I wish to have the data point be plotted in relation to the frontier but as an isolated point ...
1
vote
2answers
5k views

Get Excel to base tick marks on 0 instead of axis ends (with fixed maximum or minimum)

In other words, I want Excel to anchor the tick marks at 0. I am trying to get an axis that goes from -35 to 35, but with the ticks on multiples of 10: 30, 20, 10, 0, -10, -20, -30 I have set set ...
0
votes
1answer
3k views

Solving a linear equation with excel

Sorry if this is the wrong place to ask (Meta says it's the right place but you never know) but I'm really struggling with finding a simple answer to this. I'm using Excel 2011 for Mac, and want it ...
1
vote
3answers
13k 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
2answers
807 views

Get Excel to use column of numbers as labels (equally-spaced on x-axis) instead of as x values (x-axis co-ordinates)

It could be an easy question but I can't find a proper way to accomplish my task. I have a simple graph and all I want is to show the X values I wrote in the first column at the bottom of the graph ...
0
votes
0answers
33 views

How can I create a “spectrum” graph in Excel? [duplicate]

I'm performing some data analysis. I would like to create a "spectrum" graph like the link below to indicate the distribution of some special data occurred over a series of events. (I don't know what ...
1
vote
1answer
53 views

Tool for associative graphing

I'm looking for an app or some computational way that would help me create interactive associated lists. Basically, I have three columns of data that have many to many relationships, and when one is ...
4
votes
1answer
422 views

Line Graph using Row summations

I'm having some trouble in Excel producing a line graph for the following data: +------+--------+-----------+-----------+ | Id | Type | Owner | Date | ...
1
vote
2answers
2k views

Changing the axis labeling in a Excel 2010 scatter plot

I am trying to represent a list of data points in such a way that the graph starts at X coordinate '1' but that labeling starts at coordinate '100' and I have been unable to find out how to do it as ...
0
votes
1answer
2k views

Line Graph Adding Value of Series 1 to Series 2

I'm working on a line graph that contains two lines (each representing two different sets of data) with percentage values for each time period. In the first time period, the value for Set A is 3% ...
6
votes
2answers
11k views

How can I stop Excel from rapidly refreshing/flickering while data is being loaded from external sources?

I have an Excel spreadsheet with several charts on the same worksheet. Each chart's data comes from a different table. Each table's data is pulled from an Access database, and the connections for each ...
-1
votes
0answers
1k views

Google Spreadsheets Error: All series on a given axis must be of the same data type [closed]

I am trying to use embed interactive column charts from Google Spreadsheets for a website. However, when I enter the HTML code into the website I get the following error: "All series on a given axis ...
1
vote
1answer
586 views

Highlight a column in excel chart from a dropdown

I have a sheet with site name and associated values. Site1 100 Site2 123 Site3 432 ... Site20 234 and this is represented in a column/bar chart. there is a dropdown list of the site names. ...
0
votes
1answer
620 views

How can I create a compound bubble and pie chart?

I'm looking for a way to create a compound bubble and pie chart likes this one: I know that ManyEyes could do it, but I don't want to upload my dataset to the public. How can I accomplish this?
2
votes
1answer
14k views

Excel 2010 chart does not show x axis value

In Excel 2010, chart data series don't seem to show the X axis value. When you put your cursor on a certain data point, it shows "Series(Y axis value)"/ "Point(X axis value)"/ and "Value". The X axis ...
-2
votes
1answer
49 views

How can I draw the data in Microsoft Excel?

I have the following date in Microsoft Excel. What I want to do is make the threshold as the x-axis, and each value corresponding to the threshold (i.e; H1, H2, etc) be on the y-axis. So, for ...
4
votes
2answers
504 views

Drawing sample points versus time in Excel

I have a set of data as follow: As you can see the first column has either R or P, the second column is a measured value, and third one is obviously time. I need to present this in a chart (I ...
0
votes
1answer
737 views

Stop Excel from showing a graph value which is different from the data?

My problem is that excel graphs are showing my data differently from the data that I'm using to plot it. From the example below, the purple line Ebay/Play etc. is being plotted, but from point 28, ...
4
votes
1answer
8k views

Multiple bar charts on one axis in excel

So I have a bunch of series laid out like this in excel: I'd like to have them plotted all on one column chart but with the series separated (i.e. not clustered) so it basically is several column ...
0
votes
2answers
2k views

Excel 2007 Stacked Column Chart Display Subvalues

So I have the following set of values in my excel sheet: The values on the first column (very low, low, medium, high) are simply socio-economic layer indicators. As you can see, everything is ...
4
votes
2answers
11k views

Multiple Y-axis labels in Excel 2010 line chart

I have a table containing cycling data. Date, distance, time, calories burned, max heart rate and average heart rate. They all have different value ranges. Excel scales the chart to show the calories ...
5
votes
3answers
2k views

Any ideas for graphing data with 6 million rows?

I just tried to import it into excel, but it can only accept a little over a million rows of data. It's 3 columns of data, and all I want to do is graph column 1 against 2 and 3 for two graphs. I am ...
1
vote
1answer
7k views

conditional chart ranges in excel

I have a table of data in Excel 2010 that looks something like this (but with hundreds of thousands of rows over multiple days): I am trying to create a dynamic chart where the x-axis is the ...
2
votes
0answers
95 views

Extract data from graph with curve as axis

I need to get data from a pretty simple yet not really common type of plot (graph). If you take a look at this image, you will notice that the Y axis is irrelevant and that curve has to take its ...
2
votes
1answer
82 views

Having trouble creating certain graph in Excel

I want to create a graph which given a list of dates, will produce a line graph representing the number of occurrences of list dates. For example, this would be ideal. But when I try to recreate ...
0
votes
1answer
385 views

Visio 2010 Organization chart

I'm looking to build an org chart in Visio 2010 by using data from excel. There are many tutorials about this, so this part is pretty easy. My question is, is there a way to create automatic ...