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

learn more… | top users | synonyms (3)

8
votes
2answers
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
5answers
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
0answers
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
1answer
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
2answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
35 views
0
votes
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
3answers
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
0answers
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
0answers
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
1answer
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 ...