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

learn more… | top users | synonyms (3)

0
votes
0answers
6 views

Trying to create a line with a Primary Y and a Secondary X in a graph that has two Y and two X values

I created a chart with two X values (2015 for one and 2016 for the other) and two Y values (Hours for one and Gallons Per Min for another) by adding a secondary x and y axis. It allows me to graph ...
0
votes
1answer
26 views

Is there a way to make a single bar chart that tracks color based on date in Google Sheets or Excel?

I've attached an image that's the best way to describe it. As the date increases from left to right, a different color for that range is displayed. Some sample data: Date Temperature Week 1 ...
0
votes
0answers
13 views

excel chart mutiple data sets doesn't align properly

I'm trying to put 3 different data sets onto same chart, 2 of which use the same x-axis values (easy), and third that uses different (there is the problem). Best explained with a picture: My data: ...
0
votes
0answers
10 views

microsoft word - table of figures (inserted figures)

I have inserted captions in the maps of my document and I have created a table of figures. When I updated the table of figures some figures showed in it. Despite the fact that I deleted them from the ...
0
votes
1answer
8 views

Insert horizontal axis values in line chart

I want to insert the month names in the horizontal axis of a line chart. This should be easy to do, but after for one hour I can't figure out how to do it. This is the sheet that contains the chart ...
0
votes
1answer
14 views

Advice making a multi line chart with daily count data

This is what my raw data looks like..... raw data image I would like to use this data to create a chart that display's Install date in the X axis, a daily sum of records for each installed by name in ...
1
vote
0answers
18 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
16 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
14 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
20 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
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 ...
0
votes
0answers
15 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
33 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 ...
0
votes
0answers
31 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. ...
0
votes
1answer
21 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 ...
1
vote
2answers
30 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 ...
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
51 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 ...
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 ...
1
vote
1answer
22 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
60 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
1answer
40 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....
3
votes
1answer
42 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 ...
0
votes
1answer
46 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 -...
1
vote
1answer
39 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
2answers
31 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 ...
0
votes
2answers
36 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
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
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
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
46 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
20 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 ...
2
votes
1answer
21 views

How do I resize chart elements?

I created a pie chart in Excel 2007 and then copied and pasted it into a 2007 PowerPoint presentation. I'd like to resize the boxes on the pie charts without resizing the entire chart, but whether I ...
0
votes
1answer
61 views

How to flip X and Y axes in Excel scatter chart with more than one series [duplicate]

I don't understand how to perform a simple 90 degree axis manipulation in Excel. Here is my data: ╔════╦══════╦═══════╗ ║ Y ║ X1 ║ X2 ║ ╠════╬══════╬═══════╣ ║ 1 ║ 0.00 ║ -1.00 ║ ║ 2 ║ 0.50 ║...
-1
votes
1answer
67 views

How to represent/structure Excel table data to get Quarterly Chart?

I need to create chart similar to this one. anybody here to tell me, in order to get this kind of graph output, how Excel table data can be represented/structured? Thanks
0
votes
1answer
28 views

Graphing data points within a day

I have a spreadsheet that is a series of pings throughout a day and I need to visually represent that. I think a scatter plot is probably the best way, but I'm open to ideas and suggestions. When I ...
0
votes
0answers
20 views

Bounded logarithmic graph in excel

I have a function for which i want to draw a graph. The x values are: 99, 99.9, 99.95, 99.99, 99.9925, 99.995, 99.9975, 99.999 - so between 99 and 99.9 there are 2 values and then under 99.99 ...
0
votes
0answers
31 views

Excel 2013 XY Scatter and the label issues - something more complicated / VBA

I have a scientific machine passing values from different sensors in an Excel Worksheet including a time stamp. To have all values compared at once, I created a chart having multiple y-axes, so each ...
0
votes
2answers
95 views

Chart with categories and sub-categories in x-axis

Is it possible to have an x-axis with subgroups? For example, I need to graph Categories: Greeting (1.1, 1.2, 1.3), Call Reason (2.1, 2.2, 2.3, 2.4), Conclusion (3.1, 3.2, 3.3) , Accuracy (4.1, 4.2, ...
0
votes
0answers
25 views

Conditional formatting of “difference lines” in a 2 series chart

I have 4 columns of data: 1st column is the name of the Route 2nd column is Time1 in decimal hours 3rd column is Time2 in decimal hours 4th column is TimeDifference in decimal hours (or decimal ...
-1
votes
1answer
53 views

Creating auto-shapes in excel based on cell values

I'm trying to create (and maybe I shouldn't be using excel at all) a calendar with gantt chart style display in excel. I know there is software that is designed for gantt charts by themselves. That's ...
1
vote
1answer
34 views

Pie Chart in Excel, is it possible to have a slice for a remaining balance?

There is a budget for each employee to use on expenses. We keep track of expenses throughout the year as it gets used. At the end of the year, a lot of these budgeted dollars do not get spent and i'd ...
0
votes
1answer
134 views

Excel: How to Group Dates Per Week in Line Graph

I have data that looks like this: Actual End Date ----CP 2016-04-22------------4 2016-04-26------------3 2016-04-26------------9 2016-04-22------------7 2016-04-26------------6 2016-04-26------...
0
votes
0answers
24 views

Excell Gantt Charts or usage of room resources by blocks of time

I am trying to create a chart that shows how frequently conference rooms are booked within a month in time intervals. I have tried a Gantt chart but the times on the axis are showing 12:00AM only. ...
0
votes
1answer
59 views

Excel Dynamic Chart- Range Name based on IF formula not accepted as 'Series Name'

I have created a simple Dynamic Line Chart in Excel 2013 as seen below. As I change the Year in Cell D1, the Series on Y Axis changes accordingly. The X Axis series is static. When I use Excel Range ...