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

**0**

votes

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

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

**0**

votes

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

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

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

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

**1**

vote

**1**answer

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

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

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

**1**answer

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

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

**3**

votes

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

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

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

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

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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