Help on questions about graphs, charts and other graphical methods to show data.

**1**

vote

**2**answers

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

**-1**

votes

**0**answers

11 views

### Excel Charts in charts sheets always selected when open file

when I open an excel file with chart sheets the charts are always "selected" why is this happening. I have to unselect them by clicking outside chart.

**0**

votes

**1**answer

60 views

### Plot two time series with same start and end time: data does not align with axis

I'm trying to plot graphs for pressure and temperature recorded on different devices.
The number of data recorded for each device is different (Eg. pressure has 1 reading per second while temperature ...

**3**

votes

**1**answer

51 views

### how to create vertical line in excel for multiple charts/multiple y ranges

I am trying to add in vertical lines to my line charts to represent an important data/event, and the way I went about doing so was adding in the max value of the y range for the specific date as seen ...

**0**

votes

**0**answers

36 views

### how to get exact value from Y axis and X axix for any point in chart

I have a chart with line graph. now for a particular point on the line how can i get the exact co-ordinates from Y axis and/or X axis.
For example if the major unit on Y axis is 200 and Minor unit is ...

**1**

vote

**2**answers

25 views

### The easiest way of visualizing data from stdout as a graph?

I have an application that prints data to stdout, a floating point number about every second. I would like to visualize the numbers as a graph.
How is the easiest way to do this, preferably ...

**0**

votes

**1**answer

15 views

### How to adjust the Y Axis maximum value on a bar chart in LibreOffice Calc

How do I change a chart so that the highest values actually are at the top of the chart? Say the chart goes to 1600, but I want it to go to 1500?

**1**

vote

**1**answer

77 views

### Plotting multiple datasets of different lengths on the same scatter graph in Excel 2010

I have two data sets each containing 10 coloumns of data.
X values in data set 1 go from 380 - 750 in steps of 5
X values in data set 2 go from 250 - 2500 in steps of 1
Data set 1 is permanent and ...

**1**

vote

**2**answers

28 views

### Can you change linked charts to embedded charts in PowerPoint 2010? Or use relative links to Excel files?

I need to replicate a PowerPoint presentation across multiple countries then send the presentations to colleagues and give them the ability to edit charts.
To do this I have created an Excel file ...

**1**

vote

**1**answer

36 views

### Embed Excel Chart with Drop-down control into powerpoint

I have an interactive Excel chart which runs on the basis of users selecting ranges using drop down menus via the form control and I want to move this into Powerpoint 2010 for presentation purposes. ...

**1**

vote

**1**answer

42 views

### Given multiple start dates, how to assign counts to relative date values?

I'm trying to create a before-and-after graph in Excel, lining up multiple milestone dates at month zero, and assigning relative month numbers to months prior and subsequent to milestone month.
My ...

**0**

votes

**1**answer

31 views

### Dynamic Bars in an Excel Bar Chart

In a typical bar chart, is there a way to dynamically change each bar color based on a variable? (example: If value is 1 then bar color equal Red, If value is 2 then bar color equal yellow, etc.)

**0**

votes

**1**answer

14 views

### Creating a custom y-axis that goes 0, 80, 160, 320, 640, ect

I am wondering if there is a way to make a graph on excel with a y-axis scale based on a function y(n)=2 X y(n-1).
Specifically, I want a y-axis that has values 0, 80, 160, 320, 640, 1280.
Thanks in ...

**2**

votes

**2**answers

35 views

### Indicating trends within sparklines in Excel

I have created a load of sparklines in Excel for a variety of diseases over time. However, in order to identify trends from these sparklines, it would be useful to include a little more information ...

**1**

vote

**1**answer

19 views

### Office 2010 on Mac OS 10.8: Drawing a Chart

I have a simple data set and I want to make a graph for it.
Years Upper Band Lower Band
2010 0.73 0.63
2020 1.04 0.83
2030 1.36 1.06
2040 1.74 1.31
2050 ...

**1**

vote

**1**answer

21 views

### How do you auto update row count in a formula that yields a percentage?

How does one get a formula to auto update when a row is added when this formula is meant to yield as a percentage, which is directly linked to a pie chart? For example: my formula reads
...

**0**

votes

**1**answer

51 views

### Excel 2010 area chart drop off

I'm trying to create an area chart that shows data over a year. All the data for each month always add up to 100%.
An image is probably worth 1000 words, so here we go:
I would like the area ...

**0**

votes

**2**answers

31 views

### Difficulty Graphing Excel Data

I'd like to create an appropriate graph for the following sort of data. I'm using an example as the actual data is 1000+ lines.
Date Player Points
02/06/2014 Bob 2500
...

**0**

votes

**1**answer

25 views

### Is there a way to have groupings of bars in a bar chart in?

I know this may be bad style, but I want a bar chart that groups certain bars together. For example if I was comparing the speed of two models of cars, and considering the speed under wet and dry ...

**0**

votes

**1**answer

60 views

### How to display series name inside bars of stacked bar chart?

I have a very busy stacked bar chart, some 20 or so series over time
I am not interested in the actual numbers, I just want to show the overall trend over time.
The default colours in Excel 2010 are ...

**1**

vote

**2**answers

94 views

### How can I hide 0% value in data labels in an Excel Bar Chart

I would like to hide data labels on a chart that have 0% as a value. I can get it working when the value is a number and not a percentage. I could delete the 0% but the data is going to change on a ...

**0**

votes

**1**answer

27 views

### Add a series to a chart by pasting its formula no longer works in Excel

I used to be able to add a new series to a chart by typing or pasting a =SERIES() formula into the formula bar when a chart's PlotArea was selected, as indicated here: ...

**0**

votes

**1**answer

25 views

### Icon size of OriginLab virtualised on Mavericks

I hope that someone can help me because I'm freaking out!
I just installed Origin 9.1 on a Mac (15 retina late 2013) using parallels 10 on Windows 8.1
Everything is fine, but, due to the high ...

**0**

votes

**0**answers

68 views

### Lines over data in Excel 2013 Scatter Graph

I'm having some problems getting the plot order in a Excel 2013 scatter plot right. One series should have markers ("raw data") which should appear below series with markers and line ("fit"). The ...

**0**

votes

**0**answers

24 views

### How to build a radar graph? [duplicate]

Does anyone know how to make a graph like this? Preferably in excel or using a simple online tool? There is similar on this web-site, but not exact. I need to have 4 sections, each containing 5-6 ...

**0**

votes

**0**answers

36 views

### Organization charts in Visio 2013

I am creating an org chart in Visio 2013 from an excel file . I have linked external data to shapes so I see the external data at the bottom of the screen. If I change the external data in excel and ...

**0**

votes

**1**answer

50 views

### Export figure as PDF with surrounding white space cropped out

I exported a chart from a Microsoft Excel spreadsheet by selecting the chart, the File > Export > Create PDF/XPS document, with the following options:
The result is nice except that:
How can I ...

**0**

votes

**0**answers

27 views

### 2d density graphs with R

I would like to plot a 2D density plot using R. I have a 2 dimensional data and would like to plot it in such a way that the dense part (with data points) of the graph is represented as red and less ...

**1**

vote

**1**answer

23 views

### Excel: Plot order total in map coordinates

I have a set of data that looks like this:
-X--Y----Amount-
AE 24 $178,00
Y 27 $162,00
AD 34 $680,00
AK 35 $178,00
Y 25 $29,00
U 23 $178,00
X 38 $193,00
AC 30 $226,00
AK ...

**0**

votes

**2**answers

80 views

### Adjust decimal separator in imported charts

I am about to write an English document with the German versions of MS Word and Excel. I use Excel to create a chart which I import into the Word document (by Copy & Paste).
I can tell Excel to ...

**0**

votes

**1**answer

37 views

### One dimensional charts in excel

I have 5 measurements (series) of six values going from 1 to 6.
So,
Series 1: 1.3;2.5;3.2;3.3;3.9;5
Series 2: 1.1;2.8;3.1;4.4;4.9;5.1
...
I would like to create a scatter chart where Y-axis would ...

**0**

votes

**0**answers

83 views

### Histogram - adding vertical line (x-value) - Excel

I have created a histogram from a list of data:
-0.0892 8
-0.0711 16
-0.0529 19
-0.0348 13
-0.0166 5
0.0015 12
0.0197 5
0.0378 5
0.0560 3
0.0741 4
0.0923 5
0.1104 1
I would like to add a ...

**0**

votes

**0**answers

33 views

### Plot 3 y axis in excel

I'm trying to plot three axes on the same graph. My data headings are: date/time (x axis), water level, temp, trout up, trout down.
I've seen examples where this is possible but don't know how to do ...

**1**

vote

**1**answer

83 views

### Excel Error Bars From Pivot Table

When Excel generates Standard Error error bars, it takes into account the number of data points. If a chart was generated from a pivot table, does Excel use the number of points in the pivot table, 1, ...

**0**

votes

**0**answers

11 views

### How to format the number category in chart tags?

Hello fellow Excel users:
I have 3 desktops at home. One has Excel 2007, other one Excel 2010, and the last one Excel 2013.
As a heavy Excel user, I prefer to have 3 different versions in order to ...

**1**

vote

**1**answer

46 views

### Adjacent bar charts with different scalings

I have this chart created in Excel 2013:
using this data:
Last 4 Weeks Last 12 Months
No. of Accounts 36 186
Net Revenue 149,562 ...

**0**

votes

**0**answers

120 views

### Excel 2010, how to show percentage values on clustered columns chart?

I was looking for a better way to do this but no luck googling. My problem is about showing numeric values and percentage value in clustered column chart. When I use pie chart, there is an option to ...

**0**

votes

**0**answers

67 views

### conditional formatting of pie chart segments

i have a very simple pie chart - developed in excel for mac 2011.
each segment of the chart represents a 'group' and is sized relative to a column of data called 'count'. there is a second column ...

**1**

vote

**1**answer

70 views

### Excel chart colours

In Microsoft Excel 2010, when I insert a chart with multiple data series (or a pie chart), each series (or slice) is automatically given a colour. My 2 questions are:
What is the formula used to ...

**3**

votes

**1**answer

245 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

**1**answer

166 views

### Creating GANTT Chart (Timeline) From Start Time and Duration

I am attempting to create a daily graphical timeline from start times and duration. I have three columns: Program Name, Start Time and Duration. The data looks something like this...
The desired ...

**0**

votes

**0**answers

72 views

### Embedded excel chart in powerpoint does not print correctly from Office 2013

We have a user that has Office 2013 installed in her machine - she is the only one. The rest of the users have Office 2010. The user with 2013 is the only one with the issue.
There is a powerpoint ...

**0**

votes

**1**answer

321 views

### How to shade the area under a straight line graph in Excel

How do I shade the area under a straight line graph in Excel, along the x-axis? The graph data points are shown below.
0-16.67
170-16.67
170-6.712
187.5-6.712
652-25.352
670-33.408
910-33.408
910-0
...

**-1**

votes

**2**answers

183 views

### how to create excel charts having strings in both x and y axis

I have a student data with Student Name and their grade (A/B/C/D/E.). Now I want to have a graph for this data.
Kindly help me.

**0**

votes

**0**answers

163 views

### Excel 2013 Chart - Multiple Series on Pivot Chart

I have an Excel 2013 file that pulls data from a SharePoint list. The goal is to create a dashboard that can be refreshed easily and without formatting or updating formulas of any type.
The ...

**0**

votes

**2**answers

68 views

### Excel bar graph, easy idea, hard implementation apparently

I want to make a graph like this, but I can't seem to make it correctly:
Data: 4, 2, 3, 4, 1, 3, 3, 2, 3, 4, 2, 3, 2, 1
Three elements: Y-axis potential values (1-4 or worst, below average, above ...

**0**

votes

**1**answer

44 views

### Excel chart axis with personal label instead of number

I'm a simpleton with excel but writing a research dissertation. Much charting involved...
My y axis has values 0-6 but each number represents a patient response (for example never, very rarely, ...

**-1**

votes

**1**answer

30 views

### How do you shift data markers in excel?

How do you shift the data markers such that they align with the end of the month? The chart is shown here.

**0**

votes

**1**answer

113 views

### Chart not showing all data

I have created a very simple spreadsheet with data by half an hour for every day from Mon - Fri.
I have then created a line chart and in the legend every day is shown, however the data for Monday is ...

**1**

vote

**1**answer

160 views

### How to plot complex data as a radar chart in MS Excel?

I have some data from an experiment (which I did not design) that I'm supposed to analyze. After looking through the possible options for displaying the data to visually analyze, I believe that a ...