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

learn more… | top users | synonyms (3)

2
votes
2answers
19 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
16 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
37 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
24 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
10 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
40 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
28 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
50 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
36 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
44 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
18 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? ...
1
vote
1answer
83 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
39 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
26 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
23 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
30 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
84 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
50 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 ...
0
votes
1answer
13 views

GraphViz gui crashing on rendering

I have a .dot/.gv file that is a DirectedGraph with about 55,000 edges. When I try to render it using the GraphViz GUI in OsX it just sits a Not Responding state in Activity Monitor. I would assume ...
0
votes
1answer
38 views

Plot graph in MS Excel using multi axis

I have a table with many of lines (alice, bob, etc.) per each date: x line y 2015-04-10 alice 11032024 2015-04-10 bob 1492804 2015-04-10 clown 845033 2015-04-10 mary ...
0
votes
2answers
40 views

Adding a Secondary Axis to an Excel Chart creates gaps

I am trying to lay a line graph (on a secondary axis) over an area graph in Excel. When I have just the area graph, the graph uses the full width of the graph area. When I add the line graph and move ...
0
votes
0answers
29 views

How to update chart on cell click event in Microsoft Excel?

I want to create mark reports for N number of students. Each student's daily based marks on three subjects(Subject1, Subject2, Subject3) should be recorded. Each subject has two types of marks such as ...
1
vote
1answer
45 views

Add an area to a scatter plot in Excel

I'm desperately trying to layer an area chart on top of a a scatter plot in Excel 2013. The scatter plot has been successfully used to visualize the deviation from the mean of different Key ...
0
votes
1answer
43 views

Chart created from range of dates includes dates not in source data

I have a chart and its source data is read from a range which contains dates. When I plot it out into a chart, the x-axis includes dates that are not included in the range. How do I avoid this? For ...
1
vote
0answers
45 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
125 views

MS Excel - adding line to some series in stacked bar chart

I built the following chart after some googling: It has two levels of category axes, the bars you see are stacked bar chart types. You can find the file with the data and the charts here if you ...
-1
votes
1answer
47 views

How can I create a chart to show a possible pattern [closed]

I have 3 columns in my table. Date Day of Week # of hours 11/27/2013 Wednesday 7 2/4/2015 Wednesday 7 3/18/2015 Wednesday 7 5/2/2013 Thursday 2.5 5/15/2013 Wednesday 2.5 ...
0
votes
1answer
50 views

Plot two columns against eachother

I don't think this should be difficult, but I'm pulling my hair out trying to do it. I am trying to make a chart of age vs BMI. I have a column with age and a column with BMI. The table looks ...
0
votes
1answer
27 views

Excel 2011 plotting difference between logged sent-time / acknowledgment-time

I have an excel sheet which is a log containing the time that a message has been sent and the time that the corresponding acknowledgment for that message was received. It also contains the time ...
1
vote
1answer
59 views

Excel: Get rid of gaps in line chart

I have a table that contains the data with some absent values. If I create a line chart for that, there are gaps in place of absent values, but I'd like to have the line just follow through to the ...
0
votes
1answer
52 views

How can I make a Scattered chart in excel where the dots are different colors?

I have the following info: Question | Importance | Percentage 1 | 2 | 15% 2 | 1 | 98% 3 | 1 | 35% 4 | 3 | 22% 5 ...
0
votes
2answers
83 views

Excel Graph with 2 X-Axis Non-Linear Mapping

I have the following problem someone might be able to help with. I have two risk scales, one from 1 to 11 (old) and one from 1 to 21 (new), where the mapping is non-linear, i.e. old scale->new scale ...
1
vote
1answer
39 views

Different colored columns in excel

I have data such as this: 1 | 2 | Y 2 | 4 | N 3 | 3 | N 4 | 2 | Y ... I need a bar graph that will display column 1 as the x-axis labels with column 2 as the y values. The color of each bar will be ...
0
votes
0answers
111 views

setting upper and lower limit excel histogram

I am using the built-in data analysis tool to create a histogram for a column of numerical data in Excel. I'm doing the same thing for many different files, and they all need to have the same scale ...
1
vote
1answer
45 views

Show increase in trendline by using Excel vba

I have data in c5:c12 (sales1) and I plotted a graph and a trendline of this data. I also have data in d5:d12 (sales2). I would like to show an increase, graphically, in my existing trendline by using ...
1
vote
0answers
45 views

How to extract contour lines from a surface plot in Excel

I have several surface plots. I would like to combine one contour line from each plot into a single plot. Is there a way to extract the contour line that excel generates?
0
votes
3answers
160 views

Display excel grid lines in front of a chart?

I have an area chart in Excel for Mac 2011 that I'd like to display grid lines in front of. Is there a way to do this? I know I could make the chart semi-transparent and show the grid lines through, ...
0
votes
0answers
20 views

Decimal axis min/max in Apple Numbers

I'm using latest Apple Numbers 3.5.2 and faced with strange bug: I can't set non-integer axis min/max value, for example 0.5 or 1.75... Numbers just round it to 0, 1, 2. I tried both "0.5" and "0,5" ...
1
vote
1answer
70 views

Excel 2013 - Creating 2-data series chart with column width is dynamic (depend on variable)

Using Office 2013 suite (Excel 2013), how to I create x/y graph, we additional dependencies where X columns widths dependant on additional value? For example, from values such as: Height Width ...
1
vote
2answers
50 views

Excel data layout

I'm wanting to make a chart similar to this: The data i'm working with is different but the concept should be the same. I'm most curious in how to group x-axis (category) values. In my case I will ...
0
votes
1answer
95 views

Excel Timeline Chart (Vehicle Tracking)

Using Excel 2010 I understand how to create a Gantt Chart to simulate a timeline. Very similar to this https://ablebits.com/_img-blog/_comments/gantt-chart-months.png. My task is a little bit ...
4
votes
3answers
139 views

Excel 2013 - Is there a way to turn off a chart series without removing it

This past year i finally switched to Excel2013 from Lotus123, the only task i miss from lotus (that i can't figure out how to do in Excel) is; when formating charts and creating copies of charts it ...
3
votes
1answer
452 views

How to plot multiple actual vs target in a chart? Up down arrows? And how to show cumulative?

I have Actual vs Target data for 5 teams. Subset of data table below. I want to show: Variance target vs actual Cumulative progress towards total target What is the best way to plot this data? ...
0
votes
1answer
35 views

Changing Clustered Column Parameters in Excel

I have a quick question about how to rearrange a clustered column chart in Excel for Mac 2011. Here are the links to my data and chart: Data: Chart: I want to switch the years with the ...
0
votes
0answers
80 views

Excel chart doesn't show 'value' on hover

I have a combination chart on Excel 2013. It has both lines and stacked areas. When I hover over the lines, it shows all relevant information ('series', 'point' and 'value') of the data point. When ...
1
vote
0answers
66 views

Filtering values on Excel Pivot Chart

I'm importing data into Excel Pivot Chart from SQL Server. I'm trying to filter out Values (decimal type on SQL) below a certain threshold. For this, I click PivotChart filter and see that filter may ...
0
votes
2answers
149 views

Export excel chart to png with certain dimensions

How do i export an Excel chart to a PNG image, defining the exact size of the resulting image file? I need to export some excel charts to PNG to put them on a html page. Due to design restrictions, ...
0
votes
0answers
118 views

Automate (Macro) Excel bubble chart labels using values from cells

Is there a macro which will update Data labels in a bubble chart, when the data series change? Issue: each time I add new influencers and refresh the charts, the data labels drop out Each bubble ...
1
vote
1answer
53 views

How do I use fill color for negative values in spider chart?

Is it possible format the Spider Chart so that the negative area is always filled with red color and the positives with green. For clarification: The color filling is done manually and if the ...
0
votes
1answer
42 views

How to graph values versus time axis? [duplicate]

I'd like to use Excel 2010 to show on the x-axis when discrete events occurred and on the y-axis the magnitude of those individual spurious events. My goal is to try to visually analyse when different ...