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

**0**

votes

**1**answer

20 views

### Histogram over Time?

I am trying to track the progress of a similar variable on a number of (several thousand) objects over time. I have several snapshots of data in the following form, but I want to show the progress ...

**-2**

votes

**0**answers

10 views

### How to fix corrupted Visual FoxPro 9 dbf, dbc?

When trying to open tables I get the message "is not a table.
I have tried DBF Recovery and it did not work.

**0**

votes

**0**answers

17 views

### Excel chart referring to non-existant sheet

Apologies in advance if this question is very vague.But I'm hitting my head against the wall on this for the past 2 days and hoping someone can point out the obvious to me.
We have an Excel Report ...

**0**

votes

**1**answer

23 views

### How do I keep formatting on an Excel 2010 Pivot Chart?

I have some VBA code that runs a SQL Query, dumps it into an Excel 2010 spreadsheet and refreshes the 2 Pivot Tables based off the data. I also have 2 Pivot Charts based off of the Pivot Tables, and ...

**1**

vote

**1**answer

24 views

### How can the placement of data points in a graph be adjusted?

As part of an important presentation, I've created the following diagram showing statistical data over 5 periods of time.
The data for each period consists a pair of a bar charts with a ...

**0**

votes

**3**answers

25 views

### How to get a particular y value on a graph from Excel

Here below is my Graph:
Let's say I have a reading of 1.02 ml (the x-value from the graph) from my buret, how do I find the corresponding y-value?

**1**

vote

**1**answer

26 views

### Excel Charts: Is it possible to add specific text to the bars on a chart?

I have a chart which shows the daily purchases of each day in August 2015 against the daily purchases of each day in August 2015 in the bars, the lines show the total purchases in August 2014 for each ...

**0**

votes

**1**answer

18 views

### Excel 2013: Adding a formula / function to a chart legend

I have a chart in Excel with three legend entries. Each of them contains the word "Umsatz" and all of them are linked to cell values. Now I would like to remove that word from the entries with a ...

**5**

votes

**4**answers

90 views

### How to setup stacked bar chart to graph medication doses?

My Mom is sick (cancer) and my Dad has been writing down the times that he has administered pain medications to her. He asked me to plug it into a spreadsheet and chart it so he can visualize trends ...

**0**

votes

**1**answer

24 views

### Odd issue with Excel pie charts

I am having a weird issue that I was hoping was a quick fix with Excel 2013 for a pie chart. However, I can't figure out what's wrong! I am attempting to make a pie chart out of a column that looks ...

**1**

vote

**1**answer

37 views

### How to Fix Excel Graph to stop drawing line when data ends (not auto extend line to zero)?

I am using Excel 2010.
I am trying to graph actual expenditure data (a solid line) and extend that graph into the future (a dashed line).
I have a 5 column sheet. The first column is a date column ...

**3**

votes

**0**answers

23 views

### Excel 2010 create pie chart with labels which apply to more than one segment

I want to create a pie chart with data labels which refer to more than one segment.
I have found an approximate way of doing this - these are the steps I followed.
My data looks like this:
I want ...

**1**

vote

**2**answers

46 views

### Add Baseline to simple Excel chart

I have a simple Excel spreadsheet tracking weight loss. I have a column with dates and another with weights. I made a simple chart with both columns as data sources (dates are x, weight is y). That ...

**-1**

votes

**2**answers

82 views

### Connecting multiple series on Excel scatter plot

I am trying to create a scatter plot with multiple series and have them connected.
My data has multiple Y values for a single X value. There are 4 X values and 7 Y values for each X value for a total ...

**-1**

votes

**1**answer

47 views

### How to plot three sets of data in Excel? [closed]

I have 3 sets of data that show the specimen weight
W1 W2 W3
0 0 0
36 64 100
68 106 150
96 134 190
120 158 220
140 179 245
156 195 265
170 207 280
182 215 290
190 222 298
194 227 305
194 230 ...

**2**

votes

**2**answers

64 views

### Eliminate the appearance of a dip when plotting increasing data with smoothing

I have a data set in which Y is an increasing function of X. Here is the data:
5 | 0.1
10 | 0.789
15 | 147.5
20 | 216.5
25 | 276.5
I create an XY (Scatter) Chart with Smooth Lines:
...

**1**

vote

**0**answers

42 views

### How to create a 100% stacked column chart if I have total

I'm trying to create a 100% stacked column chart using Excel 2013 Pivot Table to show what % of Column A is of a Total Column B.
However the 100% stack column chart doesn't seem to work if I have a ...

**2**

votes

**1**answer

96 views

### Multiple Trend Lines for Different Segments of the Same Series in Excel

So I have a set of data in Excel that follows a periodic (roughly sawtooth shaped) pattern over time. That is, it increases gradually over a long period of time, and suddenly drops back down to a ...

**4**

votes

**1**answer

52 views

### How to customise labels on a secondary axis to show student progression as a flight path in Excel?

I am trying to create a line graph in Excel that plots a student's actual progression against their predicted grade. The type of graph is called a 'flight path'. This is represented as two lines on ...

**0**

votes

**2**answers

91 views

### Aligning Stacked Bar Chart w/ Scatter Plot Data

I have a scatter plot that has several data points at regular intervals, e.g. (8, 10) (8, 15) (40, 12) (40, 9), etc.
I'd like to have a stacked bar chart that lines up with these intervals, but so far ...

**1**

vote

**1**answer

34 views

### Excel chart: Poor plot of a straight horizontal line, due to settings that use “Major Unit: Fixed” for the vertical axis

I have a table of data that is the source for a chart. I import different data into the table often to plot it in the chart. In the settings for vertical axis, I selected "Major Unit: Fixed (at 1.0)", ...

**0**

votes

**3**answers

74 views

### How to tell Excel that “Years” are “Years”, not data

I have googled everywhere about this but no solution found. I have three columns in Excel:
A: Years, from 1960 to 2013
B: Maize production (in tonnes)
C. Wheat production (in tonnes)
If I make a ...

**0**

votes

**0**answers

28 views

### How can I select two data points on line graph and return its corresponding values?

I have a simple line chart and I want to select any two data points of line and wants in return its corresponding value.
For example, my 11 different points are below. Simple line graph can be drawn ...

**0**

votes

**1**answer

26 views

### Formatting time s:mm.00 in Excel (Office 2010) and graphing

My son is a competitive swimmer. I would like to make a stacked bar chart using the various time standards for each stroke. The times are listed in m:ss.00 format. I have several problems I need help ...

**0**

votes

**1**answer

31 views

### Combining 2 named ranges into a single series line chart in Excel 2010

How do I combine 2 named ranges into a single series. I have months on the X axis and average hours per month YTD on the Y axis. I want to separate the average hours into financial years i.e. the ...

**3**

votes

**3**answers

94 views

### How to make Excel chart intelligently select data

I got a set of memory usage that I am trying to plot on Excel. I got time, total RAM, used RAM, used SWAP and free SWAP each with its own column.
But if I select all of columns for a line chart the ...

**2**

votes

**1**answer

54 views

### Creating a line graph in excel with changing/result cells

For a project we are creating care packages for the homeless. I am trying to figure how many kits to make for the least leftover material as the things we are putting into the packages are sold in ...

**0**

votes

**1**answer

298 views

### Stacked column chart in Excel with the label of x-axis between the bars

I want to draw a stacked column chart in Excel and I want to put the label of the x-axis between the bars; for example:

**0**

votes

**1**answer

34 views

### Excel - Scatter plot does not connect all data points

in Excel I have a chart with 5 scatterplots. The x-axis is always the same column. However, the last added scatterplot does not connect all data points (see figure). There are some blank cells in the ...

**0**

votes

**0**answers

15 views

### Excel changes chart layout when I save as template

I created a chart layout that I like and replicate across numerous other charts. I saved it as a template. When I go to apply the template, the preview is different than my current chart. When I apply ...

**0**

votes

**1**answer

26 views

### Excel 2013: stacked bar chart with date, updating date issue

I have a stacked bar chart, with time and duration in Excel 2013 (I'm trying to show 30 day milestones). I had no problem the first time I created the file.
Now that I need to update the dates (to ...

**1**

vote

**1**answer

63 views

### Scatterplot of categorical values from pivot table

I am trying to create a scatterplot of two categorical values in Windows Excel 2013.
I tried putting the values into a pivot table, but cannot create an XY chart type with a chart that has been ...

**1**

vote

**1**answer

197 views

### Chart Series name referencing cell address Excel 2010 VBA

I am using Excel 2010.
I have a XY scatter chart built and formatted the way I like. I reuse this chart many times, so I just copy and paste the chart into a new worksheet containing the new data ...

**0**

votes

**1**answer

50 views

### Scatter plot combined with line chart

I am doing a compensation plot
I need to make a line chart with 30 grades, each having a min and max.(low and high salary within that range) On top of that, I need to plot specific employees within ...

**0**

votes

**0**answers

32 views

### how to replicate the chart on excel [duplicate]

right now i'm working on a excel chart.
Long story short, i'm looking to replicate the following interest rate project charts.
my question, how should i arrange my excel data in order to achieve a ...

**0**

votes

**1**answer

27 views

### Modifying Column Charts in Excel [closed]

I was wondering if someone might be able to help me figure out how to create a particular chart in excel. The rows are businesses and the columns are what percentage of people in area A and B that use ...

**3**

votes

**2**answers

70 views

### How to do up a excel hair chart?

I'm trying to do up a chart (on excel), the chart that I have in mind is somewhat similar to the attached picture.
Data:
X-axis: dates (weekly data)
Y-axis: interest rates
Doing this, I can ...

**0**

votes

**0**answers

15 views

### how to realize a distribution diagram (for nationalities) in crystal report

I have some database views provided by our campus management software. I have a list of matriculated students per study program (subset of faculty) with some default data (addresses, nationality, ...

**0**

votes

**1**answer

25 views

### Bar chart displaying too few days

I am trying to display a week-long step in a project. I am using the standard calendar. 8 hours per day, 40 hours per week, 31 days per month. Auto schedule. The "Days" column shows the correct number ...

**0**

votes

**0**answers

31 views

### Having trouble graphing big data in Excel (3500+ rows, 2 columns)

I really need with help this issue. I'm trying to show a relationship between two categories but the only problem is there's too much data!
Problem: Is there a relationship between X and Y?
X and Y ...

**4**

votes

**1**answer

76 views

### Add multiple series to a dynamic chart

I have a large amount of data stored in a table that is used to update about 8 charts (through named ranges). Each chart has the date and ID as the x-axis with a particular parameter being charted. ...

**0**

votes

**0**answers

13 views

### Excel 2013 Pivot Charts: will not display multiple series

I have a table of data that I copied into Excel 2013. It looks like the following:
City Month Category AvgCount
Houston, TX Jan 1 0.05
Houston, TX Jan ...

**0**

votes

**1**answer

24 views

### I cannot insert a bar chart in PowerPoint

In rerence to a previous post I too can no longer insert a chart into powerpoint. When I select chart type it allows me to click but then blinks at me and does nothing. My IT guys have looked into ...

**0**

votes

**0**answers

20 views

### Radar chart in excel - charting with intended “gap data”

I want to plot a radar chart that has cross-fire axis with text added labels at each axis. The data items to be placed between these axis points eg at 2pm, 4pm, 8pm, 10pm.
I am having difficulty ...

**1**

vote

**0**answers

17 views

### Extract numerical data from MS Word graph [duplicate]

I have a word document that includes chart objects linked to data held in unknown spreadsheets that cannot be accessed.
The charts are 'frozen', in the sense that they are displaying the data ...

**0**

votes

**1**answer

142 views

### how to combine multiple charts with same x-axis (stacking two charts) in Excel

I have 3 time series data with wildly different data ranges. I can show two of them using a primary and secondary y-axis but that does not work well with the third data series.
In Excel is it ...

**0**

votes

**1**answer

38 views

### How can I divide a drawing into a unequal size blocks using Paint.NET?

I have a magnificent set of hand drawn rune cards that I wish to scan into a runic encyclopedia of some sort. Each card is 100mm x 80mm, so I could fit 6 per A4 page to scan them. After a little edit, ...

**1**

vote

**1**answer

48 views

### Automatically updating graph that only picks out information per date

Basically what I need is a formula to look up a date in column A (yesterday), return data from Column K and M to create a graph. Column A can have 0-3 rows per day that need to go into the graph. I ...

**0**

votes

**1**answer

262 views

### How to tell Excel to plot one column on x axis and another column on vertical axis?

I intend to plot y=cos(cX) in Excel, where c is a constant produced in first cell of column C using RANDBETWEEN(-50,50). Column 'A' represents X values (from -100 to 123) and column B contains f(x) ...

**1**

vote

**0**answers

88 views

### Linear date axis in pivot tables

How do I format a PivotChart so that the horizontal axis is displayed in linear time?
See the PivotTable below as well as the source data (both excerpts).
If it is in fact not possible to ...