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

**1**

vote

**1**answer

77 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

**0**answers

171 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

**3**answers

2k 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, ...

**1**

vote

**1**answer

460 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

**2**answers

62 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

**1**answer

284 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

**3**answers

4k 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

**1**answer

2k 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

**1**answer

220 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

**0**answers

533 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

**0**answers

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

**1**

vote

**2**answers

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

**1**

vote

**1**answer

228 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

**1**answer

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

**0**

votes

**1**answer

110 views

### Is there a software or web service that allows the creation of basic flow charts from text (such as a numbered or bulleted list)? [closed]

I know of many high quality flow charting tools, online and off, but is there any that allows the very rapid creation of a flow chart, however simple, from text? I want a way to bypass all the initial ...

**0**

votes

**1**answer

130 views

### Create a bar-chart from a date column plotting the number of occurances per month

Every time I fire up Excel I find myself thinking why the heck everything is so unclear to work with. From a PHP developers perspective I often find myself copying data to csv-files and process them ...

**0**

votes

**0**answers

21 views

### graphing the temperature curve of my wood fired oven in excel 2003 [duplicate]

I just finished building a wood fired bread/pizza oven. I have 3 thermocouples installed at 3 different depths in the 7" hearth mass. I have 2 installed in the dome mass. I also get readings on ...

**0**

votes

**2**answers

139 views

### Create Excel chart showing % change (multiple industries) over time

I'd like to create a chart that shows changes in percentage for several industries over a number of years, similar to this example:
I've attempted to arrange my data to make it easier to chart, ...

**0**

votes

**1**answer

246 views

### How to plot IP address frequency distribution chart on Excel or Calc?

I have one column of data:
IP Address
1.2.1.2
1.2.1.2
1.3.4.1
1.3.4.1
1.3.4.1
1.3.4.1
1.3.4.1
1.10.0.5
1.10.0.5
1.10.0.5
2.1.2.1
2.1.2.1
12.1.2.3
12.1.2.3
12.1.2.3
12.1.2.3
12.1.2.3
12.1.2.3
12.1.2.3
...

**4**

votes

**1**answer

786 views

### Excel - How to create a stacked radar chart?

I am trying to create a stacked radar chart in Excel similar to this:
.
I have to fill color in the space between the red and blue lines. I have tried every which way I can think of but to no ...

**0**

votes

**1**answer

81 views

### How do I insert another segment into the radar pie chart that is shown on this site?

I came across this tutorial for creating a radar pie chart, and let me say it is fantastic! The problem I'm having is that I need the chart to contain 10 or even 12 segments, but I cannot figure out ...

**0**

votes

**1**answer

17k views

### How do you plot time on the X axis in excel?

I need to plot the decay of my phone's battery against time over night. My starting time is 23:17:47 and my ending one is 07:05:49. I don't have any issue in changing the time format in the current ...

**-4**

votes

**1**answer

340 views

### Consolidate Text Data in Excel

I have an Excel document containing exam results. The results are in one column and appear as Pass or Fail.
I want to know percent of candidates who passed.

**1**

vote

**0**answers

112 views

### Create a pie chart from amount/category pairs

From a table like
Amount | Category
2 A
1 B
5 A
how to create a pie chart with one sector per category found in the second colum and the summed up values for each ...

**0**

votes

**1**answer

125 views

### Placement of Secondary Horizontal Axis

On the primary horizontal axis I can go to Format Axis > Line Color and Style. There I can choose the color and style of the line that represents 0 on the primary vertical axis.
However, with the ...

**0**

votes

**1**answer

57 views

### Excel Scatterplot Graph

How would I put on set of data on the x axis and the other on the y in Excel?
Meaning suppose I had 5 people rate two different films on a scale of 10 and I organized my results like this:
Person ...

**0**

votes

**3**answers

287 views

### Excel pivot and chart - hiding field from the chart

Hi have this pivot table
the pivot table is basically as follows
Project1 - 01/01/2010 | some data
Project2 - 01/06/2010 | some data
Project3 - 01/05/2010 | some data
Project4 - 01/04/2010 | some ...

**0**

votes

**2**answers

106 views

### Excel Charts: Latency Budget / Time Management

I am trying to create a Latency Budget. This is a graph which lists each step in a process with a bar proportional to the size of the time/latency associated with this process (green), as well as ...

**0**

votes

**0**answers

108 views

### Multplie Series Scatter Plot

I need to plot multiple series from one table, all of the series on the same graph.. So when I add new data to the table I don't have to reselect all the series for the appropriate graphs. I would ...

**0**

votes

**1**answer

749 views

### individual greek letters in chart legend that comes from a formula

I'm creating a Weibull plot in Excel 2010. Each line on the chart needs a legend of this form:
my 1st data [n=250, b=2.401] { where "b" should really be a lowercase Greek beta }
my 2nd line ...

**0**

votes

**2**answers

3k views

### How to show two data series of same range but different frequencies on same graph in Excel?

I would like to show two data series (as lines) on the same graph in Excel. The two data series have different frequencies but are of approximately the same time range. To be specific, I want to ...

**1**

vote

**1**answer

466 views

### Bars In Excel Take Up More Space Than Axis

I have this graph sent to me in Excel, which I have moved into Word:
As you can see, the bars of the graph take up more space than the axis, and the bars at both ends have been cut off. Compared to ...

**1**

vote

**2**answers

274 views

### Chart macro displaying incorrect labels from non-sequential visible rows on filtered worksheet

This macro displays text labels from the source worksheet when double-clicking a dot on a scatterplot chart. The chart is updated when the source worksheet is filtered on any of several columns. The ...

**1**

vote

**1**answer

402 views

### Getting chart to ignore zeroes as a result of a formula

I'm doing a weekly log for some athletes with some data and I want to chart it as they fill it in during the week. The only issue is that for days in the week where the data hasn't been entered yet, ...

**1**

vote

**1**answer

12k views

### How to use Excel 2010 VBA to set series line color, marker fill, and marker line color

I am trying to write an Excel 2010 VBA subroutine to format charts according to a predefined (i.e., defined by me) standard. The particular attributes that I want to be able to set are merely the ...

**2**

votes

**1**answer

1k views

### how to plot on 2 axis with 3 data sets

I have a graph about tracking investment value. It has 2 Y axis scales.
First data set displays fine (left Y axis scale)
Second data set displays fine (right Y axis scale)
However when I try to ...

**1**

vote

**1**answer

493 views

### Using Chart BeforeDoubleClick with a chart object in worksheet

I am trying to get a macro to work on a chart in a worksheet using the Chart.BeforeDoubleClick event.
I have been able to use BeforeDoubleClick event (without the use of class modules) in a ...

**0**

votes

**1**answer

3k views

### Chart labeling: durations in minutes and seconds

I am attempting to chart the durations of phone interactions. They are currently entered as time of day values (I did not build the workbook), even though they are actually duration values, and Excel ...

**0**

votes

**1**answer

170 views

### How do I graph two columns not side by side?

If I have data like so:
It's trivial to generate a graph/chart of Item v Quantity. However, how do I generate more complicated graphs/charts for
Item v Items Cost.
Extended minus Items Cost ...

**1**

vote

**1**answer

223 views

### How to leave out certain rows in input data when creating a line chart [closed]

I created a line chart in Excel and manipulated the chart data that is attached to it; however, I have some rows of my chart data that I do not want displayed on the line chart. How can I make these ...

**0**

votes

**2**answers

1k views

### How to plot positive and negative values on both sides of the axis in Excel?

Could anyone please tell me how is it possible to plot a graph in Excel or LibreOffice in which different values for a single variable can be plotted on both sides of X-axis but in a way that both ...

**0**

votes

**1**answer

38 views

### In Excel 2013 can chart titles be read from a cell in the worksheet?

In Excel 2013, can the chart title and axis titles be read from cells in the spreadsheet? If so how?

**1**

vote

**1**answer

393 views

### Chart format corrupted or size is wrong when I copy from Excel 2013 to Word 2013

When I copy charts from Excel 2003 or Excel 2013 to Word 2013 the charts are corrupted:
the fonts are too big so the titles and legend text is a mess.
If I don't want the chart to update in Word ...

**0**

votes

**1**answer

2k views

### Excel 2013 charts - how can I setup default chart with distinct line colours and fonts as in Excel 2003

The default line colours in Excel 2013 have poor contrast and are not easily distinguishable. I would lie to use the same chart colours, fonts, borders, symbols etc. as was in Excel 2003. How can I ...

**0**

votes

**0**answers

764 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

**2**answers

78 views

### Finding the right graph to display inter-department connections [closed]

I have a task of displaying the interconnection between departments at my university. The idea is to show how many departments come together to work on a project. The data I have lists the projects in ...

**-1**

votes

**1**answer

269 views

### Excel 2010 Select Data making dynamic to static range

I load this into a charts Select Data field ='Metrics Test 2.xlsx'!ROFPS_Range and the chart works fine. If I change the range I am working with the formula is changed to ='UW ATO'!$B$10:$B$15 and ...

**0**

votes

**1**answer

5k views

### How to add markers to all series in an excel line chart in one go?

I have about 15 series in my chart and do not wish to manually select and edit each one individually to give it a distinct marker
Is there a way to do this for all lines in one go?
I don't care if ...

**0**

votes

**1**answer

87 views

### Excel item value data to line graphs with labels

I have a data set like this:
Set Type x y
S1 A 1 24
S1 A 2 87
S1 A 3 33
S1 B 1 66
S1 B 2 11
S1 B 3 20
S1 C 1 79
S1 C ...

**0**

votes

**1**answer

134 views

### Dynamic chart updates only when I let go of the scroll bar

I have done the usual scroll-bar to update the chart using dynamic name range. Now the problem is the chart only updates when I release the scroll bar. It does not update if I keep it pressed.
I can ...