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

**1**

vote

**1**answer

27 views

### Excel chart showing text over date

I am trying to show a chart based on a data set similar to this one.
My intention was to show possible patterns of the Items over a period of dates.
Does somebody know how I can create a chart ...

**1**

vote

**1**answer

60 views

### Connect data points around missing data with different style of line on graph

I have an libreoffice-calc spreadsheet with some results of daily measurements. Some days are missed for some reasons.
I want to create a graph showing this data, and I want to highlight all missed ...

**2**

votes

**1**answer

45 views

### Pie chart in Excel 2010 is not reading/displaying the number 0

I am trying to create a very basic pie chart in Excel with the following data:
Score Quantity
0 5
1 5
2 6
3 3
4 4
5 ...

**1**

vote

**1**answer

26 views

### Excel charts flickering/moving on screen

I previously posted this in Stackoverflow but was informed that this is a more relevant place...http://stackoverflow.com/questions/34203652/excel-charts-flickering-moving-on-screen
We have a ...

**1**

vote

**0**answers

34 views

### arranging legend labels in minitab

I want to arrange my labels shown in legend box in Minitab 17 in a way that I have my legend labels in rows instead of coloumns since I want to put my legend under my graph not beside it. I have shown ...

**0**

votes

**1**answer

94 views

### Excel Chart Series: column has data, but dialog box shows zeros

Excel 2013. My machine is a 64-bit running Windows 7.
I have an .xslm file with a chart. The chart is created from a few columns of data. The data in the columns is populated by reading data from a ...

**0**

votes

**0**answers

156 views

### How to hide zero values from an excel 3d surface graph?

I am currently trying to put together a 3D surface graph in Excel 2013. Currently, it looks like this:
The area on the left is the proper chart - displaying actual data I have. The area on the ...

**0**

votes

**0**answers

28 views

### Excel 2013 Chart showing numerical axis instead of dates

I have a bar chart that is based on a table with monthly figures (eg. 1/11/2015 | 1/12/2015, etc). When I create the table, it works perfectly with the Month and Year along the X-axis. However, I have ...

**1**

vote

**4**answers

251 views

### Manually adjust axis numbering on Excel chart

I want to adjust the X axis of my scatter diagram according to my diagram points in MS-Excel 2010. I have seen in some guides that I can change it by editing the "Axis Labels" in "Select Data". As you ...

**0**

votes

**0**answers

30 views

### can I somehow save the specification of a chart as kind of template

I have a LibreOffice Calc spreadsheet with 12 sheets, each sheet is one month. In column A I have entries of Category "Date" and in column B I have entries of Category "Time". I then make a Chart ...

**2**

votes

**2**answers

163 views

### How to duplicate the Y-axis label of a chart to the other side

I have this chart in Excel with the Y-axis automatically placed on the left side of the chart.
Aside from inserting a textbox, is there any other way to duplicate that label to the other side or to ...

**0**

votes

**1**answer

62 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

33 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

64 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

47 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

122 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 like:...

**1**

vote

**1**answer

85 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

297 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

104 views

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

Currently 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

142 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

24 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

147 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

38 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

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

**1**

vote

**0**answers

82 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

77 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

96 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

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

**1**

vote

**0**answers

78 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

22 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

125 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

31 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

103 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

34 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

49 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

154 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

31 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

120 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

25 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

467 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

48 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

2k 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

116 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

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

**6**

votes

**4**answers

277 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

87 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

874 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

157 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

5k 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

1k 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 ...