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

learn more… | top users | synonyms (3)

0
votes
1answer
971 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
452 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
90 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
206 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
706 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 ...
3
votes
1answer
13k 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. ...
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 ...
0
votes
1answer
2k 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
5k 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
3k 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
2k 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
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
475 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
32 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
45 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
215 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
1k 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
423 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% ...
5
votes
2answers
4k 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
810 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
168 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
0answers
274 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
6k 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
47 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 ...
3
votes
2answers
328 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
531 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, ...
3
votes
1answer
4k 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
1k 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
7k 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
2answers
1k 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
3k 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
67 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
75 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
192 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 ...
2
votes
0answers
183 views

MS Project 10 & 13 - Creating Custom Gantt Chart for Resource Allocation

I have created a very basic setup to better monitor staffing and scheduling decisions for my firm. Essentially, I create one task for each new project and assign the resources that will work on that ...
0
votes
2answers
2k views

Line Graph with Date on X axis and occurrence on X axis

I am trying to produce a Line graph that shows the number of access requests over a given time period to my server. The log data is like so: 10/05/2013 10/05/2013 10/05/2013 11/05/2013 11/05/2013 ...
0
votes
1answer
1k views

Optimally positioning pie chart data labels in Excel with VBA

I have a worksheet where I create a pie chart from data from a database. The chart changes based on the data it is displaying so the slices often change size. I want to display the data labels ...
0
votes
1answer
288 views

What is the best flow diagram if you have multiple processes and projects tied together like so

I have used flow charts in school and in an attempt to create a less generic chart, I figured I will share the processes and data I wish to organize.. see what ideas are available for this complex ...
0
votes
1answer
1k views

Create a graph with “string” value and not numbers

I need to create a graph in Excel that takes the values from a table that describes the products with words like "low", "middle low", "middle high", "high"; and I need that on the graph appear those ...
0
votes
1answer
75 views

Custom Chart Axis

I have an Excel chart whose X-axis values are 5000, 10000, 15000 and so-on but I want them to be like 1,2,3,... i.e. divide them by 5000. Is there any way I can accomplish this?
0
votes
1answer
411 views

Generate heatmap using list of IP addresses

I have a list of IPv4 addresses and I want to generate a heatmap of where the IP addresses are located. Is it possible to do it? IF it is possible can anyone please tell me how to do it?
2
votes
1answer
578 views

Can I provide RGB hex strings in an Excel worksheet for pie chart colors without using code?

Like user1813558 in his question "Change the pie chart colors" I would like to choose the colors that Excel uses for a pie chart (indeed for any chart) as I need them to be consistent with other data ...
3
votes
1answer
438 views

1/3 octave band chart in Excel?

I want to create a 1/3 octave band chart in Excel 2007 but I can't find the way to do it. Excel only allows me to put the 'x' axis into a logarithmic one, but the scale for 1/3 octave band is not this ...
0
votes
1answer
142 views

Column graph with multiple grouped values and one value above all of them as goal and with filled space between

I wish to create some kind of a special chart. I have 4 values, 3 are values measured over 3 years for state and the 4th is the goal where should it all go in future. The chart I want is a column ...
0
votes
0answers
325 views

Excel Radar chart to visualize data

I have a set of data with which I want to produce a Radar chart for easy comparison. This is just like an inventory list with A,B and C as the products list, I want to achieve the following : ...
2
votes
1answer
450 views

Constructing an annual cycle/radial diagram in PowerPoint

I would like to make a diagram like the below in PowerPoint, but I can't figure out how to draw the curved boxes (like the ones that say "Fishing" or "Trapping" in the chart). Diagram ...
0
votes
2answers
131 views

Excel for Mac - chart with no interpolation of discontinuities?

I would like to draw a chart in Excel for Mac with no interpolation on discontinuities, like this: How can I do that?
1
vote
1answer
827 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 ...
0
votes
1answer
341 views

Excel PivotChart count rows where not blank

I've started using Excel's PivotChart to analyze data about customer requests. All my customer requests is stored in a sheet, with columns like "City", "Inspectiondate" and "Quotedate". If there was ...
0
votes
1answer
128 views

Excel 2010 charts from ungrouped data

I have a sheet that contains lots of information about jobs in a company. One of the columns is "city". That column contains values as such Falun Borlänge Stockholm Uppsala Borlänge Stockholm ...