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

**0**

votes

**2**answers

17 views

### Adjusting manual axis numbers in Word 2010

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

**0**

votes

**1**answer

13 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

674 views

### Is it possible using Matlab to draw a trading graph with deals?

In my trading software I write myself logs like this:
634782126998342815 q 0.0156327559515302
634782126998966816 q 0.0156323845819952
634782126999122816 q 0.0156323423136646
634782126999278816 q ...

**0**

votes

**1**answer

3k views

### Excel scatter graph fill inside shape

I would like to fill the area between two graphs.
My data is in the following format:
x y
0 0
1 1
2 4
....
0 0
As you can see they start and end at the same point. For my data it draws a chart ...

**0**

votes

**0**answers

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

**1**

vote

**2**answers

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

**2**

votes

**1**answer

4k views

### Create progress bar or milestone type graphs in Excel 2007

I want to display project progress in Excel 2007. Is there a way to show a progress bar like graph filled for completed percentage and empty until end date for a milestone or the whole project? It ...

**1**

vote

**1**answer

3k views

### Visio 2013 - Flowchart Legend

I get the following error when I try to insert a legend into my visio diagram (flowchart):
There are no suitable data graphics on this page. If you apply a
data graphic, you can usa a legend to ...

**0**

votes

**3**answers

3k views

### excel - how to connect a graph max with original (0,0) point

If I have a spreadsheet that has the following data:
A
0 0
1 2
2 4
3 4
4 6
0-4 X Axis
A is Y Axis
First point is (0,0)
Second Point is (1,2)
Third point is (2,4)
...

**1**

vote

**3**answers

6k views

### Real-time graphing application for SQL data

I am looking for a free data graphing application that can pull data from MySQL and display it on a trend graph without any programming. It should use a GUI to select the data to be plotted, start ...

**0**

votes

**0**answers

289 views

### Excel chart doesn't show 'value' on hover

I have a combination chart on Excel 2013. It has both lines and stacked areas. When I hover over the lines, it shows all relevant information ('series', 'point' and 'value') of the data point.
When ...

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

**0**

votes

**1**answer

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

**5**

votes

**3**answers

2k views

### Any ideas for graphing data with 6 million rows?

I just tried to import it into excel, but it can only accept a little over a million rows of data. It's 3 columns of data, and all I want to do is graph column 1 against 2 and 3 for two graphs.
I am ...

**0**

votes

**1**answer

24 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

24 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

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

**2**

votes

**0**answers

140 views

### Excel 2010 / Outlook 2010 - Changing the size(with precise numbers) of a chart exported from Excel to Outlook?

If I export(copy&paste) charts from Excel 2010 to Outlook 2010, I'm not presented with a "size proprieties" option when trying to resize them. Since I have multiple chart to resize for each ...

**1**

vote

**1**answer

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

**2**

votes

**4**answers

23k views

### Is there a graph paper like drawing software?

I have a college assignment, where I have to draw diagrams of voronoi, delaunay, minimum spanning tree etc for the college. I want to do that in computer. I searched in google with no luck. Is there ...

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

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

**2**

votes

**1**answer

4k views

### How do I create a PivotChart from a subset of PivotTable data?

As part of a dashboard, I've created a PivotChart from a PivotTable in Excel 2010, but the PivotTable includes extra columns that are cluttering up the chart. But when I adjust the values list on the ...

**2**

votes

**2**answers

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

**1**

vote

**4**answers

37k views

### Excel or PPT: How to have two pie charts, but one legend

I would like to design a slide that shows two pie charts of the same size side-by-side, but with a single legend that is centered on the page beneath both charts. I can easily create one of the pies ...

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

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

**1**

vote

**0**answers

31 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

**2**answers

260 views

### Plotting timedata in gnuplot

I have a log file (auth.log) where non-relevant lines has been removed.
I wish to aggregate lines per hour/day into the plot, meaning that each line that is within the same hour or day is aggregated ...

**2**

votes

**0**answers

21 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

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

**0**

votes

**1**answer

3k views

### How to combine Excel charts on same X-axis

I want to create two stacked graphs in one chart object. One should be Stacked Column, and another Stacked Area. They represent revenue per partner per week of the year. On x-axis are weeks of the ...

**8**

votes

**2**answers

41k views

### Excel: How to display superscript text as data series on chart?

I have a line chart in Excel 2007 that is created from data in the worksheet. It has several series whose titles are displayed in the chart on the right side. The names of the series are of the form ...

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

**26**

votes

**8**answers

47k views

### How can I save a graph to a PNG or GIF file in Microsoft Excel?

How can I save a graph to a PNG or GIF file in Microsoft Excel?
I know I can save as an HTML file and use the image created there, but I suspect there is a way that doesn't create other clutter of ...

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

**0**

votes

**7**answers

32k views

### Excel automatic axis scale completely inappropriate for data

How can I make Excel use the correct scale on its graph axis? For example, I have a graph which looks like the following:
The x-axis has the wrong scale - it should range from about $3000 to ...

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

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

**2**

votes

**3**answers

13k views

### Creating a chart using a dynamic named range in Excel 2010

I am trying to create a scatter plot in Excel 2010 using dynamic named ranges and am having trouble getting it to work. Here's simple example that is failing:
Open Excel, starting a new workbook
...

**0**

votes

**2**answers

162 views

### Forcing axis units in Excel 2013 plots, being written after minimum bound of axis

I have a plot, drawn in Excel 2013. The data begins from almost 0.9 to almost 5.1. I want the x axis to be written from 1 to 5 and to show the data from 0.9 to 5.1.
Upon my best effort, I could set ...

**1**

vote

**5**answers

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

**6**

votes

**8**answers

76k views

### How to change x-axis min/max of Column chart in Excel?

Here i have a column chart of binomial distribution, showing how many times you can expect to roll a six in 235 dice rolls:
Note: You could also call it a binomial mass distribution for p=1/6, ...

**0**

votes

**1**answer

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

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

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