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

learn more… | top users | synonyms (3)

1
vote
2answers
1k views

Set the primary maximum and minimum Y-values equal to the corresponding secondary Y-values on a graph in Excel?

Is there a way to set the scale on a chart so that the primary maximum and minimum Y-values equal the same values on the secondary Y axis as well? Basically I have a number of different stocks I'm ...
0
votes
1answer
16 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 ...
1
vote
0answers
19 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 ...
0
votes
0answers
158 views

excel chart data labels failing to apply to all series

if I have a multiple series chart (pivot chart to be exact, can be line or bar) and I select (from the ribbon) layout data labels more data label options... then it automatically slaps ...
1
vote
1answer
14 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
21 views

Modifying Column Charts in Excel [on hold]

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 ...
0
votes
0answers
23 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 ...
2
votes
2answers
49 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
7 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
4k views

Plotting quarterly and monthly data in Excel

I have one monthly data series in one spreadsheet and one quarterly in a different spreadsheet. What is the "smartest" way to plot them together in one graph (in Excel)? Its quite a lot of data, so I ...
0
votes
1answer
2k 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 ...
3
votes
2answers
2k views

Create a stacked bar chart that displays data in monthly intervals?

I have a table with dates and prices, and I want to create a bar chart, which shows me total amount spent in months. Table looks like this: 30.5.2014 700,80 CZK 6.6.2014 1 000,30 CZK 20.6.2014 ...
0
votes
1answer
16 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
41 views

What is the most useful way to chart word frequency over time? [closed]

I want to create a chart displaying word frequency in a newspaper over time. I'm looking to chart specific words (not all words). I thought a scatter chart would be best. I would like to have the ...
6
votes
7answers
65k views

How to change x-axis min/max of Column chart in Excel?

Here i have a column chart of binomial distribution, showing how many times you can expect to roll a six in 235 dice rolls: Note: You could also call it a binomial mass distribution for p=1/6, ...
4
votes
1answer
38 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
28 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 ...
0
votes
0answers
7 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 ...
0
votes
0answers
4 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
11 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 ...
4
votes
2answers
9k views

Multiple Y-axis labels in Excel 2010 line chart

I have a table containing cycling data. Date, distance, time, calories burned, max heart rate and average heart rate. They all have different value ranges. Excel scales the chart to show the calories ...
0
votes
0answers
13 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 ...
0
votes
1answer
42 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 ...
1
vote
0answers
70 views

Excel Charting - How to edit the X axes for positive value on both sides?

I have a stacked chart, with the X axes at bottom. So there are two bars protruding along the y axes from each category. to get an idea of the X axes, it's something like this How to plot positive ...
0
votes
1answer
3k 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
1answer
3k views

excel - how to connect a graph max with original (0,0) point

If I have a spreadsheet that has the following data: A 0 0 1 2 2 4 3 4 4 6 0-4 X Axis A is Y Axis First point is (0,0) Second Point is (1,2) Third point is (2,4) ...
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 ...
3
votes
1answer
4k 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 ...
2
votes
2answers
35 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 ...
0
votes
1answer
26 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
2answers
4k views

Excel chart with a single x-axis but two different ranges (combining horizontal clustered bar and horizontal stacked bar), possible?

I am new here. I have a data set of density values (phytoplankton community) according to depth and the composition of it in percentage. I want to ask if it is possible to construct the density values ...
1
vote
1answer
580 views

Cannot insert charts into PowerPoint 2013

I cannot insert charts into PowerPoint 2013. Each time I wish to, once I have selected the desired chart type and click 'OK', it simply blinks (exits and reopens). It then returns me to the same ...
1
vote
2answers
1k views

How to highlight calendar cells based on given start and end date

For a while now, a coworker has been using a chart similar to the one shown below and wants to automate it (i've already added the days before/after due date). The chart is printed or worked on at ...
2
votes
1answer
3k views

How do I create a PivotChart from a subset of PivotTable data?

As part of a dashboard, I've created a PivotChart from a PivotTable in Excel 2010, but the PivotTable includes extra columns that are cluttering up the chart. But when I adjust the values list on the ...
1
vote
1answer
34 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
53 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
4answers
30k 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 ...
1
vote
0answers
32 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
1answer
18 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
67 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
2answers
29k views

Scatter chart, with one text (non-numerical) axis

Lets imagine I manage 100 pizza stores. I want to plot a chart each day, of how long deliveries are taking. My data might look like this: London 23 London 22 London 44 London 18 ...
0
votes
0answers
41 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 ...
2
votes
3answers
14k views

How to highlight data points in a scatter chart in excel?

I have a scatter chart with a series of numbers in Excel. Most of the time, those numbers are high (>1000). I would like to display the scatter chart with those numbers in the default color, but if ...
1
vote
1answer
40 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 ...
0
votes
0answers
20 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
69 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 ...
0
votes
1answer
3k views

How to create a 4 variables chart in excel? [closed]

I have been trying to figure out a way to create a chart with 4 variables in Excel. I can get to 3 with no problem but the 4th variable seems not possible. Here is my data (I am working with decoding ...
1
vote
1answer
2k views

What are the labels for minor ticks in a log scale graph? [closed]

What are the labels for the minor ticks in a log scale graph? I would like to label them. So, I want to know how to calculate the value for each of the minor tick.
1
vote
1answer
88 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 ...
1
vote
2answers
58 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 ...