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

learn more… | top users | synonyms (1)

0
votes
0answers
13 views

How to build a radar graph?

Does anyone know how to build 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
4 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
27 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
15 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
34 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
15 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
19 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
24 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
1answer
25 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
9 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
30 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
25 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
21 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
43 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 ...
2
votes
1answer
51 views

How to 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
50 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
46 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
43 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
79 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
0answers
28 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
1answer
34 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
1answer
28 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
1answer
23 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
72 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
2answers
372 views

Excel: How to Superimpose 2 Stacked Column Charts

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
30 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
104 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
51 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
71 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
91 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
41 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 ...
0
votes
1answer
32 views

Microsoft Excel chart with dynamic series

I am working on creating a excel template file that includes charts generated from the data added. One of the charts displays trending data over 12 months for an unknown number of products. The ...
-1
votes
1answer
32 views

Plot multiple sets of x,y data on a single chart

Have several series of data I want to plot on the same chart: Series A Y X 4015188 7361762 4020374 9581526 4022289 10649655 4023878 11223132 4025512 12035416 4028600 13408580 4030353 ...
2
votes
3answers
106 views

How to fill in missing dates in chart

I'm looking for a simple way to chart a list of values each correlating to a date. For example: Date Value 11/7/13 2 11/8/13 2 11/11/13 3 11/14/13 2 Etc. The problem is, the chart does ...
0
votes
2answers
30 views

Finding trends in multi-category data in Excel

I have an Excel spreadsheet that contains hundreds of rows of data that each represent a single sample in a larger population. Each row is divided into three columns that contain frequency counts of ...
-1
votes
1answer
30 views

Extract chart data from Word document to CSV files automatically

I have lots of charts in a Word document in docx format. If I click on Edit data, I get an Excel window which displays the data. From there, it's easy to export it to CSV. How is it possible to ...
3
votes
1answer
58 views

How to antialias trendline in Excel?

I have created a couple of line charts in Excel 2011 for Mac. The actual data line looks good and is antialiased in a nice way but when I then add a trendline it is jagged and ugly: I have tried ...
0
votes
1answer
65 views

Adding text axis labels to excel scatter chart

I have a Spreadsheet with data like this Label Data PA_1 1 PA_2 2 PB_1 3 with hundreds of rows. I want to create a scatter graph where the x-axis contains the names in the label column. ...
2
votes
1answer
625 views

Advanced Chart in Excel - column width based on cell value

I am an intermediate excel user struggling to create a specific chart for an internship project. I have spent a lot of time trying to figure it out and have searched the web extensively. Below is an ...
4
votes
2answers
172 views

Linked images in PowerPoint not updating

First of all, excuse me if this question is asked on the wrong StackExchange site. I have a PowerPoint (2010) presentation with two slides. Both slides contain an image (two different images), and ...
0
votes
2answers
36 views

Having some issues making specific line charts in Excel

I am sorry if this is a dumb question, but I need to pass a graph to excel and I'm failing to do so. I have no idea where to fix it. Basically I already have one on Matlab, but I want to remake it ...
0
votes
1answer
135 views

Excel area chart - y axis and major grid does not match 1 of the 2 series values

Using an area chart to show survey responses as two series with four data points in each. The x-axis are the four answer choices, the y axis is the percentage of respondents. The problem is the data ...
0
votes
0answers
525 views

How to get data series in Highchart from a JSON POST request (cross domain)

I'd like to create my own Highstock's chart on a local html file by using the JSON data series retrieved with a POST request to a third-party domain. I've read several docs on Highcharts' website but ...
0
votes
2answers
102 views

Excel Charts - How do i plot time on the Y axis

I am a keen runner and am trying to plot my progress on a chart using the following times 00:27:18 00:28:19 00:26:49 00:27:19 00:26:05 00:27:18 00:26:22 00:26:49 00:30:40 00:28:03 00:26:58 00:27:35 ...
0
votes
1answer
81 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
votes
1answer
311 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 ...
0
votes
2answers
88 views

How to make a 3D chart in excel

I found the same question but I'm not getting a 3D looking chart as posted in the answer. My data looks like this: 5 7 11 15 19 0.1 28 21 12 9 7 0.2 22 14 9 ...
0
votes
1answer
236 views

graph in excel to represent correlation of 3 parameters

I have some data in excel and I would like to make a graphical representation of those data. Structure of my data: persons ID : from 1 to 485 to every person, there is one parameter like average ...
0
votes
1answer
42 views

Excel Chart Timeline

I have a CSV file that I have opened in Excel 2011 for Mac. The CSV looked like this: Timestamp | URL 01/Jan/2014:01:01:01 /path/to/something1 01/Jan/2014:01:01:05 ...
1
vote
1answer
113 views

Display numbers twice on x axis in excel chart

I have following values that I would like to display on the X axis of my chart: 0,1,2,3,4,5,6,7,8,9,10,10,10,9,8,7,6,5,4,3,2,1,0 But my chart is displaying the values as ...