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

**8**

votes

**2**answers

13k views

### Program for reading data off scanned graphs [closed]

I know such thing exists, because I used it somewhat long ago ... the problem being I cannot remember what it's called.
I have some graphs from which I need to read off points (numeric values). The ...

**1**

vote

**0**answers

17 views

### Is there any way to put a thermometer chart inside of the category name on another chart?

I'm using Excel 2016 and have a bar chart showing Manhours/Actual Hour. I want to make the horizontal category labels have a separate bar chart within them, showing time spent out of time possible (...

**1**

vote

**1**answer

15 views

### Excel 2016 won't break down data for a chart

I just started MS Office 2016 Excel on my Mac, but I can't get it to create pie charts for me. Even if I choose a column of data, it seems Excel thinks it is a single piece of data. Switching between ...

**1**

vote

**0**answers

8 views

### Date axis with Pivot Chart (Excel 2016)

I have a list of dates across the X-axis of the form mm/dd/yyyy and have the pivot field formatted as a date. When I attempt to format the axis to be a date axis, Excel does nothing. I can literally ...

**0**

votes

**1**answer

18 views

### Show middle hierarchy in Excel treemap?

I have a CSV with filesystem data; file paths and size. I've created a treemap chart from this data, but the problem is that the treemap doesn't seem to take hierarchy into account. Each data point, ...

**1**

vote

**1**answer

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

**0**

votes

**1**answer

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

votes

**0**answers

14 views

### How do I transfer data values from a chart to a table on Excel?

I have data that is listed in a chart, for example
Hello1
World2
Biscuit3
I would like to transfer this to a data table, but the numbers follow a specific pattern. For example, the table would be:
...

**1**

vote

**0**answers

10 views

### Charts / text boxes in Word not appearing properly when saving as PDF

I have a Word document (Office 2007) that I'd like to save as a PDF. Most of the document saves perfectly, but some pie charts and text boxes are not appearing correctly in the PDF. They don't appear ...

**1**

vote

**5**answers

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

14 views

### Switch Excel chart from stacked by category to sum

I have 2 charts that shows invoice figures by month. The figures are broken down into categories. Is there any way to have an option to use the same chart to show them stacked by category OR the sum ...

**0**

votes

**1**answer

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

**0**

votes

**2**answers

9k views

### How do I create bar charts with ranges as the x-axis in Excel 2010?

I am trying to create a bar chart for say some data, say for example
1 1 2 2 3 4 5
I want to create a bar graph so each bar shows the frequency of a range. For example, the frequency of a value ...

**0**

votes

**1**answer

31 views

### Convert text into a hierarchy chart

I was using Microsoft Paint to make a hierarchy chart, but realized that it is no good as you cannot easily modify text and shapes once you click away from them.
So I tried libre/open office and a ...

**8**

votes

**1**answer

32k views

### Plot date and time of an occurrence

I need to plot (over a period of day measurements) date of occurrence and time. An example is "we are tracking Billy's occurrences of aggression, date and time of the event". How can I show this?

**0**

votes

**0**answers

142 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:...

**0**

votes

**1**answer

20 views

### Creating a “grouped” bar chart from a table in Excel

Firstly, I have almost no experience with Excel charts. :)
I'm trying to create a fairly simple chart from a fairly simple table. But I'm having more problems than I thought I would have and spending ...

**0**

votes

**0**answers

19 views

### xmgrace fails to load after installation

I installed xmgrace via Homebrew on my machine (Macbook pro running os x 10.11.5) but when I execute xmgrace on the command line I see the following error:
Warning: Widget must be a VendorShell.
...

**1**

vote

**2**answers

29 views

### Export whole excel sheet with chart to png

Say if you got a fancy excel sheet with chart and numbers, is there a way to export what you see into a PNG or some image file?
I tried something:
1 Excel=>PDF=>PNG: doesn't work; crop by page (I ...

**2**

votes

**1**answer

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

28 views

### Single data series with both primary and secondary axis (in two different units)?

Is it possible to plot (line graph) a single data series and display both a primary axis and secondary axis, showing two different units? Currently I have the different y-axis units as a separate ...

**1**

vote

**1**answer

47 views

### Is it possible to add some vertical lines to a Waterfall Chart in Excel 2010?

I'm using a (modified) Waterfall Chart to show progress while tracking IT Certifications (amount) on a monthly basis. This is intended to be an ongoing work but all I'll be tracking is the last 12 ...

**3**

votes

**2**answers

108 views

### Plot the area between two curves

I have a function with a parameter z similar to the above one:
y = sin(x+z)
How can I plot the values of y as a function of x and all the possible values of z in the [0.1, +0.1]?
I want to graphic ...

**2**

votes

**1**answer

28 views

### Line chart in LibreOffice - data in rows (type, x, y) rather than in a 2-input table

How do I create a line chart in LibreOffice Calc if the data is organised in 3-tuples rather than in a two-input table?
Example:
Banana Jan 10
Banana Feb 20
Banana Mar 30
Banana ...

**3**

votes

**1**answer

864 views

### Can this 5-attribute 2D risk map be built in excel?

So there is this risk map (or heat map otherwise) below (*):
What is interesting is that in the a 2D image there the following attributes are mapped:
Attribute -------- Drawing component
1. ...

**0**

votes

**1**answer

804 views

### How can I create a compound bubble and pie chart?

I'm looking for a way to create a compound bubble and pie chart likes this one:
I know that ManyEyes could do it, but I don't want to upload my dataset to the public. How can I accomplish this?

**1**

vote

**1**answer

21 views

### Horizontal Axis of Line Chart Does Not Adjust - Excel

I have a line graph whose source data come from a pivot table. However, the number of rows in this pivot table may change and the chart's horizontal axis do not adjust to that. How can I adjust my ...

**0**

votes

**0**answers

8 views

### Disable pie chart shape protection in Visio 2013

I have a pie chart I have rotated so the slices are symmetrical. I want to rotate the text in the right image to horizontal.
I've tried
The Master Explorer
The Shape Design Protection button
...

**0**

votes

**1**answer

31 views

### Excel Graph Display Data

I have been attempting to create a line chart where my month data is on the left and my name is on the bottom, and for the graph data labels are added to show the count for the past 90 minutes and I ...

**0**

votes

**1**answer

59 views

### Microsoft Excel Data Table

So I have a lot going on with my current table, I use it for showing my portfolio in a snap:
Except it's lacking a pretty looking pie chart. Here's the thing, I can do what others have suggested. ...

**0**

votes

**2**answers

35 views

### How can I get the secondary horizontal axis to the left and primary horizontal axis to the right in MS Excel 2013?

How can we get the secondary and primary horizontal axis to the left and right side respectively?

**0**

votes

**1**answer

38 views

### How do I make a horizontal single row high low close chart?

I am using MS excel 2013.
I would be grateful if someone could point me in the direction of a function or workaround in excel that will help me to build a small single line chart to be included in a ...

**0**

votes

**1**answer

32 views

### Space values in line graph by Y value instead of equally

If I have a table of data that looks like this:
Time (seconds) Data
1.1 4
1.2 4
1.31 7
1.4 8
1.91 11
2 9
2.1 5
2....

**6**

votes

**2**answers

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

**3**

votes

**1**answer

41 views

### Can I convert a list of names directly into a pie chart in Excel?

I've asked a group of 50 students who their favourite teacher was. The survey has exported the data and I've sorted it, so the list is now something like:
Abrams
Abrams
Butler
Cromwell
Cromwell
...

**1**

vote

**1**answer

40 views

### Find the number of points between two “scatter with smooth lines” series

I've attached an image that shows the scatter plot I've built in Excel. I need to know how many points are between the dashed line series and the solid line series just to the inside of the dashed ...

**0**

votes

**1**answer

45 views

### Create graph of values, mean per day, grouped by variable

I have a spreadsheet containing the following values (slightly simplified):
Date - day in number - Temperature - Windspeed - Hours of sun. Data example:
01-09-2000 - 01 - 20 - 15 - 9
02-09-2000 - 02 -...

**0**

votes

**2**answers

28 views

### Pasting Spreadsheet from Excel to Outlook, chart gets distorted

I have been able to copy a full workbook in the past and simply paste it into outlook to send the data set that I need to send. I recently updated the data set and included more data and now when I ...

**1**

vote

**1**answer

38 views

### How to generate an excel chart that includes aggregating and grouping

My data looks like this
Date Time Person Logged in
June 1 2PM John
June 1 2PM Chris
June 1 3PM John
June 2 2PM Chris
June 2 3PM Bill
June 2 4PM Bill
I want to ...

**0**

votes

**1**answer

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

**-1**

votes

**2**answers

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

**3**

votes

**3**answers

19k views

### How can I hide 0% value in data labels in an Excel Bar Chart

I would like to hide data labels on a chart that have 0% as a value. I can get it working when the value is a number and not a percentage. I could delete the 0% but the data is going to change on a ...

**0**

votes

**1**answer

12 views

### Excel scatter plot with two x series and one y series

My data consists of a y value and the two x values that can be used as inputs to a quadratic equation to give the y value. I'd like to plot them, ideally with separate colours for the positive and ...

**1**

vote

**0**answers

40 views

### Excel Pivot chart with a legend summary table having SUM and COUNT of values

I have a pivot chart display some data I'm interested in. Using a summary table below the chart I can plot the SUM of the values. This works great for me since the data rows contains a 1 if I want to ...

**1**

vote

**1**answer

77 views

### Dynamically choose a chart measure in Power BI

I have a number of charts within a single dashboard in Power BI, as well as a number of measures that I want to examine individually within this dashboard - hopefully by cycling through them.
...

**0**

votes

**2**answers

25k views

### Plot multiple sets of x,y data on a single chart

Have several series of data I want to plot on the same chart:
Series A
X Y
4015188 7361762
4020374 9581526
4022289 10649655
4023878 11223132
4025512 12035416
4028600 13408580
4030353 ...

**0**

votes

**1**answer

3k views

### How do I group and chart date ranges in Excel?

I want to visualize the use of vehicles in a family through time. I have collected the dates each vehicle was being used as follows (example data) :
And want to somehow chart the data to visualize ...

**0**

votes

**0**answers

20 views

### How do I plot two different data sets that have different x-axis?

My question is probably better explained with example data, so here's what I'm trying to plot and compare on the same graph/chart:
First Data Set:
Percentage A | Price A | Price B
5% | $0.25 | $0.37
...

**0**

votes

**0**answers

43 views

### Add total to pivot chart

I have a set of data of all the stops in the plant here. The data is arranged in columns as followed:
Column A Fabrication number
Column B Start Date
Column C End date
Column N observation (this is ...

**0**

votes

**1**answer

17 views

### How to plot a line chart with multiple “Y” axis variables of different units?

I have a dataset with multiple variables all correlated to time. I am interested in plotting these variables on Y axis and time on the X axis. I have seen so many posts that talk about using ...