# Tagged Questions

45 views

### How to create a stacked bar chart that displays data in monthly intervals?

I have a table with dates and prices, and I want to create a bar chart, which shows me total amount spent in months. Table looks like this: 30.5.2014 700,80 CZK 6.6.2014 1 000,30 CZK 20.6.2014 ...
92 views

### Superscripts in Excel chart labels

I have data like this: 2 | 5 4 | 6 8 | 7 I want to plot them (scatter plot) with x={2,4,8}, y={5,6,7} but in the x-axis show 2 as 2^1, 4 as 2^2, 8 as 2^3, but not with the ^ symbol but as powers/ ...
446 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 ...
283 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 ...
113 views

### combining two plot type in excel

I want to combine xyline plot with bar plot in excel. I created xyline plot and then added new series with a hope that I can chance the series 1 later. Step1: But it turned to be not true, see the ...
1k 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 ...
432 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 ...
2k 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 ...
302 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 ...
148 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: ...
987 views

### How to draw a 'sane' scatter plot in Excel?

I've been at it for over 2 hours now and am just a bit flustered :) I have the following data (for example): Label | Criterion 1 | Criterion 2 | A1 | 7 | 3 | A2 | 1 ...
295 views

### How make this graph in Excel?

I'm trying to do this kind of graph in Excel, but nothing so far. I don't find anything like it, but it has to be this way, not bars. starter 22,58 20,76 7,1 37,93 68,42 professional ...
131 views

### Excel 2007 plot with labeled data items

I have data in the following format, where each label defines a row of data: label1 x1 y1 label1 x2 y2 label1 x3 y3 label2 x1 y1 label2 x2 y2 label2 x3 y3 This is a very large data ...
584 views

### Excel 2007 adding mean value and variance to histogram

I have to visualize a trend and I was wondering if it is possible to show a red line over a range of data for the mean value(data range) and the variance(data range). Example: Data: a,b,c,d,... ...
2k views

### Excel 3 dimensional stacked bar chart howto

One of our guys in the office wants to do a proper 3D stacked bar chart. In other words, he is not just interested in having a 3D rendering of the bars, but he needs full 3 dimensions for his data (x ...
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 ...
2k views

### How do I make the first row of an Excel chart be treated as a heading when it's a number?

Given a data sample like Prisoner 24601 0.50 Day 1 80 90 Day 2 81 89 Day 3 82 90 Day 4 81 91 What's the easiest way to tell Excel that 24601 and 0.50 are data series names rather ...
14k views

### How to create a Wind Rose plot in Excel 2007?

I am attempting to create a wind rose graph, i.e. My data is wind speed and cardinal wind direction in separate columns: Wind (mph) Wind Direction 3.66 SE 2.69 SE 2.62 SW ...
629 views

### Graphing Time in the Y-Axis creates duplicate entries?

I'm trying to create a graph based on Times and Dates and the Times on the Y-AXIS are being created with duplicate values. I attached a screenshot with the problem, the 0:00 can be seen twice. Does ...
1k views

### Excel: ROUND() to the next unit of 5?

I'm creating a lot of graphs, so I'm making a common scale to be able to compare them using MAX/MIN values that I'm hiding in the graph as a separate series. My Vertical AXIS (Y) is in units of 5. ...
2k views

### Excel graphs: I have created a template graph format but how do I apply it?

I've created a format that I like. I now need to apply this format to over 900 graphs! I've seen we can save a format as a template for future use, however, I can't find the place where I have the ...
421 views

### Excel Graph: How can I turn data below in to a 'time based' graph

In my spreadsheet I am collecting time periods when certain values have been changed. The user is restricted to 4 time periods. I would like to show the data based on thos time periods. I've included ...
65k views

### how to add an average line to the graph in excel 2007 or 2010

In OpenOffice I'm getting trend-line and average-line properties by RightClick. But in Excel 2007 I see only trend-line. Same with Excel 2010. How do you make an average-line in Excel?
6k 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?