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

learn more… | top users | synonyms (3)

0
votes
2answers
33 views

Aligning Stacked Bar Chart w/ Scatter Plot Data

I have a scatter plot that has several data points at regular intervals, e.g. (8, 10) (8, 15) (40, 12) (40, 9), etc. I'd like to have a stacked bar chart that lines up with these intervals, but so far ...
1
vote
1answer
21 views

Excel chart: Poor plot of a straight horizontal line, due to settings that use “Major Unit: Fixed” for the vertical axis

I have a table of data that is the source for a chart. I import different data into the table often to plot it in the chart. In the settings for vertical axis, I selected "Major Unit: Fixed (at 1.0)", ...
0
votes
2answers
62 views

How to tell Excel that “Years” are “Years”, not data

I have googled everywhere about this but no solution found. I have three columns in Excel: A: Years, from 1960 to 2013 B: Maize production (in tonnes) C. Wheat production (in tonnes) If I make a ...
0
votes
0answers
21 views

How can I select two data points on line graph and return its corresponding values?

I have a simple line chart and I want to select any two data points of line and wants in return its corresponding value. For example, my 11 different points are below. Simple line graph can be drawn ...
0
votes
1answer
24 views

Formatting time s:mm.00 in Excel (Office 2010) and graphing

My son is a competitive swimmer. I would like to make a stacked bar chart using the various time standards for each stroke. The times are listed in m:ss.00 format. I have several problems I need help ...
0
votes
1answer
20 views

Combining 2 named ranges into a single series line chart in Excel 2010

How do I combine 2 named ranges into a single series. I have months on the X axis and average hours per month YTD on the Y axis. I want to separate the average hours into financial years i.e. the ...
3
votes
3answers
82 views

How to make Excel chart intelligently select data

I got a set of memory usage that I am trying to plot on Excel. I got time, total RAM, used RAM, used SWAP and free SWAP each with its own column. But if I select all of columns for a line chart the ...
2
votes
1answer
36 views

Creating a line graph in excel with changing/result cells

For a project we are creating care packages for the homeless. I am trying to figure how many kits to make for the least leftover material as the things we are putting into the packages are sold in ...
0
votes
1answer
64 views

Stacked column chart in Excel with the label of x-axis between the bars

I want to draw a stacked column chart in Excel and I want to put the label of the x-axis between the bars; for example:
0
votes
1answer
14 views

Excel - Scatter plot does not connect all data points

in Excel I have a chart with 5 scatterplots. The x-axis is always the same column. However, the last added scatterplot does not connect all data points (see figure). There are some blank cells in the ...
0
votes
0answers
12 views

Excel changes chart layout when I save as template

I created a chart layout that I like and replicate across numerous other charts. I saved it as a template. When I go to apply the template, the preview is different than my current chart. When I apply ...
0
votes
1answer
16 views

Excel 2013: stacked bar chart with date, updating date issue

I have a stacked bar chart, with time and duration in Excel 2013 (I'm trying to show 30 day milestones). I had no problem the first time I created the file. Now that I need to update the dates (to ...
1
vote
1answer
43 views

Scatterplot of categorical values from pivot table

I am trying to create a scatterplot of two categorical values in Windows Excel 2013. I tried putting the values into a pivot table, but cannot create an XY chart type with a chart that has been ...
1
vote
1answer
57 views

Chart Series name referencing cell address Excel 2010 VBA

I am using Excel 2010. I have a XY scatter chart built and formatted the way I like. I reuse this chart many times, so I just copy and paste the chart into a new worksheet containing the new data ...
0
votes
1answer
30 views

Scatter plot combined with line chart

I am doing a compensation plot I need to make a line chart with 30 grades, each having a min and max.(low and high salary within that range) On top of that, I need to plot specific employees within ...
0
votes
0answers
31 views

how to replicate the chart on excel

right now i'm working on a excel chart. Long story short, i'm looking to replicate the following interest rate project charts. my question, how should i arrange my excel data in order to achieve a ...
0
votes
1answer
26 views

Modifying Column Charts in Excel [closed]

I was wondering if someone might be able to help me figure out how to create a particular chart in excel. The rows are businesses and the columns are what percentage of people in area A and B that use ...
3
votes
2answers
63 views

How to do up a excel hair chart?

I'm trying to do up a chart (on excel), the chart that I have in mind is somewhat similar to the attached picture. Data: X-axis: dates (weekly data) Y-axis: interest rates Doing this, I can ...
0
votes
0answers
10 views

how to realize a distribution diagram (for nationalities) in crystal report

I have some database views provided by our campus management software. I have a list of matriculated students per study program (subset of faculty) with some default data (addresses, nationality, ...
0
votes
1answer
18 views

Bar chart displaying too few days

I am trying to display a week-long step in a project. I am using the standard calendar. 8 hours per day, 40 hours per week, 31 days per month. Auto schedule. The "Days" column shows the correct number ...
0
votes
0answers
29 views

Having trouble graphing big data in Excel (3500+ rows, 2 columns)

I really need with help this issue. I'm trying to show a relationship between two categories but the only problem is there's too much data! Problem: Is there a relationship between X and Y? X and Y ...
4
votes
1answer
52 views

Add multiple series to a dynamic chart

I have a large amount of data stored in a table that is used to update about 8 charts (through named ranges). Each chart has the date and ID as the x-axis with a particular parameter being charted. ...
0
votes
0answers
9 views

Excel 2013 Pivot Charts: will not display multiple series

I have a table of data that I copied into Excel 2013. It looks like the following: City Month Category AvgCount Houston, TX Jan 1 0.05 Houston, TX Jan ...
0
votes
1answer
15 views

I cannot insert a bar chart in PowerPoint

In rerence to a previous post I too can no longer insert a chart into powerpoint. When I select chart type it allows me to click but then blinks at me and does nothing. My IT guys have looked into ...
0
votes
0answers
15 views

Radar chart in excel - charting with intended “gap data”

I want to plot a radar chart that has cross-fire axis with text added labels at each axis. The data items to be placed between these axis points eg at 2pm, 4pm, 8pm, 10pm. I am having difficulty ...
1
vote
0answers
17 views

Extract numerical data from MS Word graph [duplicate]

I have a word document that includes chart objects linked to data held in unknown spreadsheets that cannot be accessed. The charts are 'frozen', in the sense that they are displaying the data ...
0
votes
1answer
59 views

how to combine multiple charts with same x-axis (stacking two charts) in Excel

I have 3 time series data with wildly different data ranges. I can show two of them using a primary and secondary y-axis but that does not work well with the third data series. In Excel is it ...
0
votes
1answer
30 views

How can I divide a drawing into a unequal size blocks using Paint.NET?

I have a magnificent set of hand drawn rune cards that I wish to scan into a runic encyclopedia of some sort. Each card is 100mm x 80mm, so I could fit 6 per A4 page to scan them. After a little edit, ...
1
vote
1answer
44 views

Automatically updating graph that only picks out information per date

Basically what I need is a formula to look up a date in column A (yesterday), return data from Column K and M to create a graph. Column A can have 0-3 rows per day that need to go into the graph. I ...
0
votes
1answer
82 views

How to tell Excel to plot one column on x axis and another column on vertical axis?

I intend to plot y=cos(cX) in Excel, where c is a constant produced in first cell of column C using RANDBETWEEN(-50,50). Column 'A' represents X values (from -100 to 123) and column B contains f(x) ...
1
vote
0answers
56 views

Linear date axis in pivot tables

How do I format a PivotChart so that the horizontal axis is displayed in linear time? See the PivotTable below as well as the source data (both excerpts). If it is in fact not possible to ...
2
votes
2answers
37 views

How to add padding to images/chart in MS Word with 'in line with text' wrapping?

I have a justified paragraph at the end of a two column page. On inserting a chart with "in line with text" mode under text wrapping in the middle of the paragraph, the image appears fine. How can I ...
2
votes
1answer
19 views

Excel grab address to start y values series

I have the string $F$50 created by the CONCATENATE function. I also have a scatter plot where the selected data is like this: =SERIES(,data!$A$4:$A$404,data!$F$4:$F$404,1) I want to replace $F$4 in ...
3
votes
1answer
86 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
0answers
78 views

Excel - Adding titles to both ends of an axis in a scatter plot

I'm looking for a way to add axis titles to both ends of an axis in a scatter plot in Excel 2016 for Mac. So far I have titles only in the left and bottom parts and want to add the titles on the ...
0
votes
0answers
30 views

Using I/O graph how to interept bytes/tick against packet details information?

I'm working on a trace-file which has reported ISP throttling occurrences in it. My task is to use IO graph to understand at what point in time the throttling process effected client upload ...
0
votes
2answers
107 views

(Excel) Plotting data series and a subset of that series on one chart

I have a data series associated with text labels. I'm trying to fit a line to the second half of my data. I read that in order to do so I have to make a second data series consisting of the subset of ...
1
vote
1answer
51 views

Plotting multiple datasets of different lengths on the same scatter graph in Excel 2010 (extended)

I would like to plot multiple datasets of different length on the same scatter graph. This question was already answered exactly here: Plotting multiple datasets of different lengths on the same ...
1
vote
2answers
65 views

Creating a chart with two different scalings on the y-axis [duplicate]

I want to create a chart with two different scalings (steps of 500 and steps of 10.000) on the y-axis. This is needed because there is a fixed cost of 1000 (so a straight line from left to right) and ...
2
votes
1answer
45 views

Excel pivot table - unable to get graph to display correctly

I have a pivot table (Excel 2013) of results for a helpdesk. In column A it lists the agents, grouped by year (this divides up into months). In column 2 it lists the number of tickets closed by each ...
0
votes
2answers
261 views

Day of the week and Time Graphing in Microsoft Excel

I have an Microsoft Excel document with two columns, date (mm/dd/yyyy) and time HH:MM(a/p). Each row represents an order (The day it was placed and the time it was placed). How can I graph this so ...
2
votes
1answer
19 views

generate line graph from spreadsheet with month and category column?

Trying to generate a line graph that shows the amount a certain category happened per month. The spreadsheet has the category of an instance as well as the month it occurred. Easy way to do this? ...
0
votes
0answers
9 views

plotutils: `graph` creates empty plots

I'm trying to create simple plots using graph as described in this tutorial. However, even the most basic example: echo 0 0 1 1 2 0 | graph -T png > plot.png produces a perfectly white 570x570 ...
1
vote
1answer
301 views

How to make a concentric pie chart in Excel?

I'd like to make a chart (preferably on its own sheet) that is a combination of a regular pie and a doughnut. The regular pie sits in the middle and the doughnut surrounds it. I have seen those ...
0
votes
1answer
64 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 ...
0
votes
1answer
36 views

How to chart two columns of data in excel

I have the following data and I want to create a simple chart in Excel 2010 but can't work out how to get this to work. I've tried scatter charts, switching axes, etc. and nothing seems to give me ...
0
votes
1answer
36 views

How to include image(.png) in legend of an excel chart?

All, I am trying to include company logos as legends of excel charts instead of their names automatically using VBA. Any leads will be highly appreciated.
0
votes
1answer
36 views

Bar chart from data in one column in Excel

Call me stupid but every time I want to perform an easy task in Excel I end up using Google to find a solution. Today's mission impossible is to create a bar(or pie) chart from data located in one ...
1
vote
1answer
97 views

Excel chart for rail car movements

I need to display the movements of a group of rail cars between two locations. Each car has dates for "left location A", "arrived location B", "left location B", "arrived Location A" - repeatedly ...
2
votes
1answer
75 views

Data retention on storage devices?

Is there any official table out there that shows how many years can a storage device retain data before it becomes unreadable? Storage devices: USB memory sticks, classic hard drives, SSDs, optical ...