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

learn more… | top users | synonyms (1)

-1
votes
0answers
13 views

How can I use 2 information on 1 Y axis graph?

please help. I want to create a column bar graph that shows 2 information, one is the actual number and another is the annualized number. Can it be stacked but with different style (the annualized ...
-1
votes
2answers
35 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
24 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 ...
-1
votes
0answers
13 views

how to create excel charts having strings in both x axis and y axis [duplicate]

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. Description: Hai, I was tried to plot a graph having two fields (NAME and Gradde like ...
0
votes
1answer
18 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 ...
2
votes
3answers
12k views

Excel or PPT: How to have two pie charts, but one legend

I would like to design a slide that shows two pie charts of the same size side-by-side, but with a single legend that is centered on the page beneath both charts. I can easily create one of the pies ...
1
vote
1answer
3k views

Plot scatter graph in Excel graph with 3 variables in 2D

3 Columns of Data: Date (from 1st till 31st) Variable 1 variable 2 I want to make a simple graph where Variable 1 range is X axis and Variable 2 range is Y axis, I plot the date on the graph ...
0
votes
0answers
15 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
30 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
2k views

Adding 80% horizontal goal line to pivot chart

I have a curve pivot chart to which I'd like to add a goal line with a static 80% horizontal line. I've seen some people suggest that one could merely add a column with 60% to the dataset. My dataset ...
-1
votes
1answer
21 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
16 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 ...
0
votes
1answer
3k views

Excel scatter chart, with grouped text values on the X axis

Apples 1 Apples 5 Apples 2 Bananas 1 Bananas 4 Bananas 6 I want two bars on the X axis (Apples, Bananas), but with crosses marking the points on the Y axis. Here's a mockup: I'd want 1 ...
1
vote
1answer
40 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
299 views

How do I disable screen updating while reformatting an Excel 2007 chart?

I have a chart with about 70,000 data points. When I format the axes or data series, Excel automatically updates the chart before I am finished editing the value. This is very slow (1+ minutes), even ...
1
vote
2answers
126 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
27 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
87 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 ...
3
votes
1answer
7k views

Excel generate and format horizontal error bars

I have been trying to generate and format horizontal and vertical error bars in Excel 2010, and there is no problem with the vertical ones, but I cannot figure out how to manage horizontal error bars. ...
0
votes
1answer
42 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
26 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
3k views

Plotting quarterly and monthly data in Excel

I have one monthly data series in one spreadsheet and one quarterly in a different spreadsheet. What is the "smartest" way to plot them together in one graph (in Excel)? Its quite a lot of data, so I ...
0
votes
1answer
50 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: ...
2
votes
3answers
19k views

XYZ 3D-chart in Excel

I have a table of data as follows: X Y Z N1 2 5 6 N2 2 7 8 N3 0 1 2 N4 0 4 5 N5 9 10 10 N6 4 9 9 N7 0 2 4 N8 0 7 8 N9 0 7 8 Now I would like to ...
1
vote
1answer
25 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
28 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 ...
2
votes
1answer
1k views

Zero values in Excel logarithmic chart: Can the warning be suppressed?

I'm plotting data in an Excel 2003 chart with a logarithmic scale on the Y axis. Some data points are occasionally missing, and this is represented by blank cells. The resulting graph looks like the ...
-1
votes
1answer
26 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
46 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
25 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 ...
3
votes
1answer
46 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 ...
3
votes
1answer
12k views

How to create dynamic Scatter Plot/Matrix with labels and categories on both axis in Excel 2010?

Let us consider a following data set: Name | Age | Hair Color ----------------------------- John | Young | Brown Sophie | Old | Blond Adam | Mature| Blond Mark | Teen | Dark Jeremy | ...
-1
votes
1answer
18 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 ...
0
votes
1answer
40 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. ...
4
votes
2answers
122 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 ...
2
votes
1answer
234 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 ...
10
votes
2answers
337 views

How to turn a 3D chart into something watchable on a 3D television?

Let's say I have a 3D scatter plot in R or a data frame with 3 fields filled with numeric data. How can that be "turned" into "something" watchable on a 3D television (like a random big screen TV ...
0
votes
2answers
33 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
68 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
238 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 ...
1
vote
2answers
3k views

In an Excel chart, how do you craft X-axis labels with whole number intervals?

I have a sorted list of values that I'd like to see graphed in an Excel chart just to see the shape of the curve. Here is the initial chart: Looks ok, but the X-axis is ugly, so lets clean that ...
0
votes
2answers
51 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
50 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
vote
3answers
6k views

Creating a chart using a dynamic named range in Excel 2010

I am trying to create a scatter plot in Excel 2010 using dynamic named ranges and am having trouble getting it to work. Here's simple example that is failing: Open Excel, starting a new workbook ...
-1
votes
1answer
118 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
75 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
110 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
32 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 ...
3
votes
1answer
26k views

How to rename the values on Y Axis in Excel?

I'm trying to rename the values that are on my Y Axis on a chart in excel. Currently I have mapped various letters to number equivilants just to get it plotted, but would like now to have the letter ...
1
vote
1answer
77 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 ...