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

**0**

votes

**0**answers

5 views

### Can I format the Y-axis in this way?

I'm using Excel version 15.15 on a late 2014 Mac Mini running El Capitan 10.11.1.
I am trying to represent 3 things; Profit & Loss for Rates & FX and for Credit (two different asset classes), ...

**0**

votes

**1**answer

17 views

### Excel Chart Axis Formatting

I want my axis on my charts to display numbers to the tenth. So instead of 2 or 3, I want the axis to read 2.0 and 3.0. Please help. I have already rummaged through the format setting and am lost.

**0**

votes

**1**answer

23 views

### How to format stacked bar chart correctly

I'm trying to make a stacked bar chart for some transactions made within the year. Ideally, the x-axis is month, the y-axis is amount, and the stacks (layers) are vendor name. But I can't get it ...

**2**

votes

**1**answer

23 views

### Pin line/arrow to bar-chart elements

I'd like to pin some lines in order to follow the movement of stacked 100% bar-chart elements. As you can see from the screenshot below
Right behavior
the arrow are more or less in the middle of ...

**1**

vote

**0**answers

22 views

### Stacked Line graph line colors do not match legend

I made an interactive chart that shows different data, depending on which ActiveX checkboxes are checked. I created a few tables that would show different data by using a few nested IF statements ...

**1**

vote

**1**answer

15 views

### Duplicate Chart in OpenOffice Calc without losing link to the sheet's data

I have created and formatted a chart and need the same one again to be filled with other data. The problem: In OpenOffice Calc 4.1.1, a chart's data is unlinked from the original data/sheet, as soon ...

**1**

vote

**1**answer

64 views

### Dispersion graph in Excel

I need to draw a dispersion diagram in Excel, but that must be vertical, not horizontal.
I have this table and need to graph the "Weighted" column:
When I try, I get this horizontal graph:
What ...

**0**

votes

**0**answers

42 views

### Format datatable using VBA (values are as Double but String is needed for formatting)

urrently working on a vba script that makes charts automatically. I would like to add a datatable which is done using:
.HasDataTable = True
However I would like to show the values of series as ...

**2**

votes

**2**answers

74 views

### Excel survey data pivoting, plotting and analysis

I have a set of data from Google forms survey. I ran into a problem representing the data for a specific question type, grid to be exact.
So for example you get a question like this one:
and ...

**0**

votes

**0**answers

23 views

### Excel changing data order in chart

I have an excel chart with the source data sorted from largest % to smallest % by salesperson. However, the chart that is created from that data set is showing the data listed alphabetically in the ...

**1**

vote

**0**answers

30 views

### Programmatically rotate a pie chart to fix the labels

Part 1
I'm looking at a way to automatically rotate (with VBA) a pie chart depending on the data. The data is changed dynamically depending on the month selected. Here is an example of the kind of ...

**2**

votes

**0**answers

20 views

### How to set a non-linear Y axis on a graph in Word?

I need draw the chart similar type with the chart below but I don't know how to set up the Y axis value and resize to view as this.

**1**

vote

**1**answer

42 views

### Excel - X-axis issues when combining x-y scatter and column charts

I want to superimpose a column chart on an x-y scatter chart. I have done that by adding a series (for the column chart), creating a new y-axis for the values, etc. However, the x-axes don't work out. ...

**0**

votes

**0**answers

9 views

### how to generate a graph with asciidoc?

I was checking out this asciidoc tutorial and really liked the graph at a,b,c,d so i create such a file with that ascii text 1.ad went ahead and installed asciidoctor chrome extension but it just ...

**1**

vote

**1**answer

35 views

### Creating a distribution chart in Excel

I would like to replicate
in Excel, which groups hundreds of occupations under 12 major job categories, and plots them according to number of jobs and probability of computerisation.
I currently ...

**2**

votes

**2**answers

26 views

### How to use a number range as the x-axis on an excel bar chart?

I have some data that I want to translate into a bar chart in Excel, however I am unsure on how to make it so my x-axis is in the correct format I need it in.
Here is the Excel data:
And here is ...

**0**

votes

**0**answers

28 views

### Graph of large data set of 5 billion records

I have a csv file of more than 5 billion entries in it.
I want to create a line or area chart for this data.
Which software I can use to do so.
The file size is 34GB.

**-3**

votes

**0**answers

12 views

### generate performance graph from counters

I need some advice on following issue:
I have 8 servers, for each server I have a list of XML files which are generated every 15 mins, each file contain couple of counters (like memory, network, cpu, ...

**1**

vote

**0**answers

22 views

### Excel chart shows horizontal axis as the same value after pivot refresh

I have created a simple clustered column chart to display request volumes (y-axis) over time (x-axis, months). All of that is linked to a little CountIf table that sources data from a PivotTable (as ...

**0**

votes

**2**answers

17 views

### Avoiding one broad column in PivotChart in Excel

When I have a PivotChart in Excel that only has one column, that column gets unnecessarily big and broad. How do I retain that size somewhat, even though its only one column?

**-1**

votes

**2**answers

48 views

### Creating a even time axis in Excel when you have a uneven time values

I am creating charts for the valuation of startups, based on new funding rounds. I want a time axis (X) that has evenly distributed time, even though the data points may not be evenly distributed. ...

**0**

votes

**0**answers

16 views

### Excel PowerPivot m2m with time series

I have a dataset which I have simplified a bit for this post. From the image you can see that I have two data tables. They essentially list the estimated output from two 'facilities', and the actual ...

**0**

votes

**1**answer

40 views

### Removing dates when there is a year gap between data in excel graph

I am trying to create a share price graph with historical share price and future estimate price in one year time.
When i plot the graph I am using the historical prices for the year , which is not an ...

**0**

votes

**0**answers

26 views

### Get time plotted data to automatically line up in correct date order regardless of blank cells

I have a set of data points plotted over time. Time is plotted monthly and the results for Suplhate (example given) are plotted quarterly. Results are entered in the same month every quarter for each ...

**2**

votes

**0**answers

33 views

### Legend-placement in two different charts is different with same settings

I have two charts, and in both of them I want I want to place the legend in the upper right corner of the chart-area like so:
However when attempting to add a legend to the second chart, it is ...

**1**

vote

**1**answer

40 views

### Excel Chart with data points not in chronological order

Say you have total monthly spend for 36 months and you want to display it in a bar graph to show all the spend for the 3 Januarys, then all the spend for the 3 Februarys, etc. When I sort my data ...

**0**

votes

**1**answer

20 views

### Change linked data in a chart embedded in Word

I have set up six charts on a page, so that they're all the same size and formatting. But at the moment there are only two distinct charts and each one has three versions. I did this because I didn't ...

**0**

votes

**1**answer

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

**0**

votes

**0**answers

20 views

### Excel chart referring to non-existent sheet

We have an Excel Report generated by a Java Process with all charts and jazz. The report has 10 tabs. The very first report has a "Walk Chart" generated. Unfortunately, the chart is displaying ...

**0**

votes

**1**answer

74 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

32 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

67 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

38 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

45 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

134 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

40 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

102 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

**1**answer

51 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

260 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

237 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

70 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

76 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

142 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

248 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

79 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

315 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

42 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

77 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

56 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

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