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

learn more… | top users | synonyms (3)

1
vote
1answer
67 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
0answers
24 views

Plotting two data sets with measurements at different scales

I'm doing research on a rock core with tools that measure different things over different lengths. One will give me a reading every foot , the other will give me a reading every 2in. I am trying to ...
0
votes
1answer
48 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
1answer
21 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
2answers
68 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
1answer
36 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
1answer
95 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
1answer
434 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
2answers
68 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
1answer
45 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
1answer
3k 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 ...
2
votes
2answers
2k 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
1answer
35 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
1answer
58 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
0answers
266 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
0answers
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
0answers
94 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
1answer
209 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 ...
1
vote
1answer
33 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
2answers
1k 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
1answer
221 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
0answers
437 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
0answers
98 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 ...
2
votes
1answer
524 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
0answers
12 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
1answer
142 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
0answers
219 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
0answers
195 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
1answer
215 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
1answer
1k 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
866 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
0answers
160 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
1answer
2k 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
2answers
447 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.
1
vote
1answer
1k 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
2answers
127 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
1answer
67 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, ...
0
votes
1answer
1k 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
1answer
361 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 ...
1
vote
0answers
63 views

Format Excel to Display Second Time Zone in Graph

I need to make my Y axis in a graph show the time in HH:MM (local) format as well as HH:MM +/- offset for another timezone. Form example: 09:00 EST 06:00 PST Is there some sort of custom format ...
0
votes
1answer
222 views

Using multiple data sources in a scatter graph

I have a script that runs something in a loop and writes its duration into a .csv file on a share. The file looks like this: "timestamp","duration","ComputerName" "7/8/2014 2:56:03 ...
1
vote
2answers
10k views

How to Superimpose 2 Stacked Column Charts in Excel

I have two stacked column charts (with no gaps between the columns) that have identical X- and Y-axes with same intervals. One graph is displayed in red, while the other graph is displayed in blue. ...
1
vote
0answers
51 views

Excel: Replace Number Format in Diagram

I have an Excel Workbook which will be sent to a client and I need to get the thousands and decimal seperators right. I have a Workbook.Open routine which will change to custom formatting (and back on ...
2
votes
1answer
227 views

Excel: How to create a nonuniform stack chart

I want to create a stack chart that shows the timeline of 3 phases on the x-axis (intervals separated by month) and total budget on the y-axis. The budgets for all projects will stack up against each ...
0
votes
1answer
436 views

Excel 2007 VBA Export range as jpg file is trucating picture

I have a workbook with many different ranges of data with 77 lines or more. I need to copy them and save as JPG files, which will be used by other application. Below is the example of code that I'm ...
0
votes
1answer
204 views

Creating pie chart template for dynamic data

I am trying to create a pie chart template so that i can write data source dynamically through my java program and template will create the chart once after the data is added. Please refer the example ...
0
votes
1answer
749 views

In microsoft excel 2013, how do you find where a data point would intersect with an already plotted line?

I have a graph with one series of data, with a trend line and an associated trend line equation (y = mx + b). I have another series of data, but only of y-values. I want to find the x-values of this ...
0
votes
1answer
333 views

Pie Radar Chart outline series not working

I have been trying to create a Pie Radar Chart as described in answer to this question. Everything works until I get to the section that describes inserting a series to create the chart's outline: ...
1
vote
1answer
630 views

LibreOffice graph axis label

I have made a graph out of about 20 lines of dates and 20 lines of values, but the graph doesn't show all the dates, which really bugs me, it just shows 'month' difference: I would like to have ...
1
vote
1answer
44 views

Using exported Google Play statistics in Excel

I have exported data from Google Play statistics, but I got this: date,total_user_installs 20140618,291 20140617,291 20140616,291 20140615,290 20140614,289 20140613,289 20140612,288 20140611,286 ... ...