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

**0**

votes

**0**answers

6 views

### How to make Excel scatter plot axis show months rather than days?

I have an Excel scatter graph that is separating months into 20-day segments instead of the entire days of each month. How do I fix this? I want to have it reflect the days of the month by simply ...

**0**

votes

**0**answers

12 views

### Can Excel automatically create an x-axis range?

I'm doing a basic financial analysis with Excel. The gist of it is I have an input parameter (discount rate) plus a bunch of static data that gets fed into the =NPV(rate, x1...x_i) function. I would ...

**-1**

votes

**0**answers

19 views

### Excel: making a chart evaluating two binary conditions

I have several sets of data in binary text form: them/us, win/loss, up/down. A row might look like
Them | Them | Up | Win
I'd like to make a chart evaluating this data. Ideally, I'd like a chart ...

**0**

votes

**1**answer

23 views

### Excel Scatterplot Graph

How would I put on set of data on the x axis and the other on the y in Excel?
Meaning suppose I had 5 people rate two different films on a scale of 10 and I organized my results like this:
Person ...

**0**

votes

**3**answers

23 views

### Excel pivot and chart - hiding field from the chart

Hi have this pivot table
the pivot table is basically as follows
Project1 - 01/01/2010 | some data
Project2 - 01/06/2010 | some data
Project3 - 01/05/2010 | some data
Project4 - 01/04/2010 | some ...

**0**

votes

**2**answers

29 views

### Excel Charts: Latency Budget / Time Management

I am trying to create a Latency Budget. This is a graph which lists each step in a process with a bar proportional to the size of the time/latency associated with this process (green), as well as ...

**-2**

votes

**1**answer

85 views

### Open source software for generating swimlane graphics? [closed]

I have a bunch of data, and I'd like to automate the creation of a swimlane diagram from it, and I'd like to do so with open source software on Linux.
http://en.wikipedia.org/wiki/Swim_lane
Edit
I ...

**0**

votes

**0**answers

14 views

### Export animated PowerView scatter chart from Excel

I recently discovered the wonderfully cool capability of Excel to do an animated timeline akin to the type created by Hans Rosling (see his remarkable TED Talk The best stats you have ever seen as ...

**0**

votes

**0**answers

29 views

### Multplie Series Scatter Plot

I need to plot multiple series from one table, all of the series on the same graph.. So when I add new data to the table I don't have to reselect all the series for the appropriate graphs. I would ...

**0**

votes

**1**answer

24 views

### individual greek letters in chart legend that comes from a formula

I'm creating a Weibull plot in Excel 2010. Each line on the chart needs a legend of this form:
my 1st data [n=250, b=2.401] { where "b" should really be a lowercase Greek beta }
my 2nd line ...

**0**

votes

**0**answers

16 views

### Percent Completion Pie Chart in Apple Numbers

I want to create a pie chart in Apple Numbers with two data sources. I want the percent completion of a goal. Let us say the goal is 4 and so far we completed 1. I would like to have both 1 and 4 ...

**0**

votes

**2**answers

48 views

### How to show two data series of same range but different frequencies on same graph in Excel?

I would like to show two data series (as lines) on the same graph in Excel. The two data series have different frequencies but are of approximately the same time range. To be specific, I want to ...

**1**

vote

**1**answer

18 views

### Bars In Excel Take Up More Space Than Axis

I have this graph sent to me in Excel, which I have moved into Word:
As you can see, the bars of the graph take up more space than the axis, and the bars at both ends have been cut off. Compared to ...

**1**

vote

**2**answers

55 views

### Chart macro displaying incorrect labels from non-sequential visible rows on filtered worksheet

This macro displays text labels from the source worksheet when double-clicking a dot on a scatterplot chart. The chart is updated when the source worksheet is filtered on any of several columns. The ...

**1**

vote

**1**answer

54 views

### Getting chart to ignore zeroes as a result of a formula

I'm doing a weekly log for some athletes with some data and I want to chart it as they fill it in during the week. The only issue is that for days in the week where the data hasn't been entered yet, ...

**1**

vote

**1**answer

167 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

**0**answers

22 views

### how to plot on 2 axis with 3 data sets

I have a graph about tracking investment value. It has 2 Y axis scales.
First data set displays fine (left Y axis scale)
Second data set displays fine (right Y axis scale)
However when I try to ...

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

**0**

votes

**1**answer

49 views

### Chart labeling: durations in minutes and seconds

I am attempting to chart the durations of phone interactions. They are currently entered as time of day values (I did not build the workbook), even though they are actually duration values, and Excel ...

**0**

votes

**1**answer

24 views

### How do I graph two columns not side by side?

If I have data like so:
It's trivial to generate a graph/chart of Item v Quantity. However, how do I generate more complicated graphs/charts for
Item v Items Cost.
Extended minus Items Cost ...

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

**0**

votes

**2**answers

47 views

### How to plot positive and negative values on both sides of the axis in Excel?

Could anyone please tell me how is it possible to plot a graph in Excel or LibreOffice in which different values for a single variable can be plotted on both sides of X-axis but in a way that both ...

**0**

votes

**0**answers

17 views

### Formatting a chart with many data points for a small display area

In Excel 2013, I need to display a chart with dates on the X axis and errors (already computed) on the Y axis. The problem is that I have 916 data points taken every six hours spanning approximately ...

**0**

votes

**1**answer

18 views

### In Excel 2013 can chart titles be read from a cell in the worksheet?

In Excel 2013, can the chart title and axis titles be read from cells in the spreadsheet? If so how?

**1**

vote

**1**answer

55 views

### Chart format corrupted or size is wrong when I copy from Excel 2013 to Word 2013

When I copy charts from Excel 2003 or Excel 2013 to Word 2013 the charts are corrupted:
the fonts are too big so the titles and legend text is a mess.
If I don't want the chart to update in Word ...

**0**

votes

**1**answer

36 views

### Excel 2013 charts - how can I setup default chart with distinct line colours and fonts as in Excel 2003

The default line colours in Excel 2013 have poor contrast and are not easily distinguishable. I would lie to use the same chart colours, fonts, borders, symbols etc. as was in Excel 2003. How can I ...

**0**

votes

**0**answers

25 views

### excel chart data labels failing to apply to all series

if I have a multiple series chart (pivot chart to be exact, can be line or bar) and I select (from the ribbon)
layout
data labels
more data label options...
then it automatically slaps ...

**0**

votes

**2**answers

27 views

### Finding the right graph to display inter-department connections [closed]

I have a task of displaying the interconnection between departments at my university. The idea is to show how many departments come together to work on a project. The data I have lists the projects in ...

**-1**

votes

**1**answer

33 views

### Excel 2010 Select Data making dynamic to static range

I load this into a charts Select Data field ='Metrics Test 2.xlsx'!ROFPS_Range and the chart works fine. If I change the range I am working with the formula is changed to ='UW ATO'!$B$10:$B$15 and ...

**0**

votes

**1**answer

52 views

### How to add markers to all series in an excel line chart in one go?

I have about 15 series in my chart and do not wish to manually select and edit each one individually to give it a distinct marker
Is there a way to do this for all lines in one go?
I don't care if ...

**0**

votes

**0**answers

11 views

### Displaying data correctly in a chart Word 2013

On the horizontal axis on this graph, I only have data for 1, 5, and 25. I want the graph to display as if i had 25 values and have the data show it respectively.
For example, instead of reading
1 ...

**0**

votes

**1**answer

30 views

### Excel item value data to line graphs with labels

I have a data set like this:
Set Type x y
S1 A 1 24
S1 A 2 87
S1 A 3 33
S1 B 1 66
S1 B 2 11
S1 B 3 20
S1 C 1 79
S1 C ...

**0**

votes

**1**answer

29 views

### Dynamic chart updates only when I let go of the scroll bar

I have done the usual scroll-bar to update the chart using dynamic name range. Now the problem is the chart only updates when I release the scroll bar. It does not update if I keep it pressed.
I can ...

**0**

votes

**0**answers

51 views

### PowerPoint 2010 - Electrocardiogram -like chart

I need to make a chart in PowerPoint (PowerPoint 2010) that is like an electrocardiogram, actually is a chromatogram, I'm trying with line charts but I can't get the "peaks" of the line. I mean, in a ...

**0**

votes

**1**answer

66 views

### How to keep Excel line graph from incorporating dates that are not in my range

I have created a line graph based on dates and the values associated with those dates. However, it is inserting dates into a graph which I do not want. The dates run in chronological order, I only ...

**0**

votes

**0**answers

30 views

### Label distribution and scaling in Numbers

I'm currently working in OS X Numbers on a document with two columns and 1078 rows.
Using this data, I have constructed a simple 2D line graph which I am fairly happy with.
The issue that I'm having ...

**0**

votes

**1**answer

53 views

### A chart where the line between points does not interpolate

I have an Excel spreadsheet showing the balance of a bank account over time. Each data-point is the balance of the account immediately after a transaction (so there might be several per day, with the ...

**1**

vote

**1**answer

122 views

### How to draw an excel chart from two columns?

Consider the following table:
1970 - 4705
1980 - 4771
1990 - 4998
2000 - 5181
2001 - 5195
2002 - 5205
The left number is x, the right is f(x). (The numbers are in separate excel columns)
I need to ...

**0**

votes

**0**answers

11 views

### How do I configure the plot area to display my entire series of data?

The simplest way to describe my question is to view this image:
When I click on the series (i.e. the bars, you can see that the "shadows" of the non displayed bars are displayed outside the plot ...

**0**

votes

**1**answer

23 views

### Excel Chart Object without source data in Word going back to Excel

I have an Excel object chart in word. The chart is a line graph. The data is there because when I mouse over the line, I see each individual x and y value. However, the word file chart was sent to me. ...

**2**

votes

**1**answer

736 views

### Excel: How to create (truly) blank cells from formula so that they wont show up in a chart?

I have a table where track data on a daily base, compare it to a daily target I have set, calculate the gap between the two and display the data on a line chart.
The data has 4 columns:
A. Date (from ...

**0**

votes

**0**answers

61 views

### Excel 2010 Chart Not Printing To Size

I have an excel spreadsheet that I am trying to print with a chart located in it. The chart is properly sized in the spreadsheet and looks fine when viewing it in the editor. When I go to print the ...

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

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

**0**

votes

**1**answer

184 views

### Plot two time series with same start and end time: data does not align with axis

I'm trying to plot graphs for pressure and temperature recorded on different devices.
The number of data recorded for each device is different (Eg. pressure has 1 reading per second while temperature ...

**3**

votes

**1**answer

276 views

### how to create vertical line in excel for multiple charts/multiple y ranges

I am trying to add in vertical lines to my line charts to represent an important data/event, and the way I went about doing so was adding in the max value of the y range for the specific date as seen ...

**0**

votes

**0**answers

302 views

### how to get exact value from Y axis and X axix for any point in chart

I have a chart with line graph. now for a particular point on the line how can i get the exact co-ordinates from Y axis and/or X axis.
For example if the major unit on Y axis is 200 and Minor unit is ...

**1**

vote

**2**answers

42 views

### The easiest way of visualizing data from stdout as a graph?

I have an application that prints data to stdout, a floating point number about every second. I would like to visualize the numbers as a graph.
How is the easiest way to do this, preferably ...

**0**

votes

**1**answer

44 views

### How to adjust the Y Axis maximum value on a bar chart in LibreOffice Calc

How do I change a chart so that the highest values actually are at the top of the chart? Say the chart goes to 1600, but I want it to go to 1500?

**1**

vote

**1**answer

887 views

### Plotting multiple datasets of different lengths on the same scatter graph in Excel 2010

I have two data sets each containing 10 coloumns of data.
X values in data set 1 go from 380 - 750 in steps of 5
X values in data set 2 go from 250 - 2500 in steps of 1
Data set 1 is permanent and ...