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

learn more… | top users | synonyms (3)

0
votes
0answers
13 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
0answers
8 views

Displaying data correctly in a chart Word 2013

On the horizontal axis on this graph, I only have data for 1, 5, and 25. I want the graph to display as if i had 25 values and have the data show it respectively. For example, instead of reading 1 ...
0
votes
0answers
11 views

is there any player that automatically convert HD movies to standards only? [on hold]

my Lenovo netbook was not so new, I have a problem when im wathching HD movies on my netbook. I hate it when it gets pixelated whenever I watched on it. OR is this a problem on my video card?
0
votes
1answer
23 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
1answer
16 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 ...
0
votes
0answers
28 views

PowerPoint 2010 - Electrocardiogram -like chart

I need to make a chart in PowerPoint (PowerPoint 2010) that is like an electrocardiogram, actually is a chromatogram, I'm trying with line charts but I can't get the "peaks" of the line. I mean, in a ...
0
votes
1answer
34 views

How to keep Excel line graph from incorporating dates that are not in my range

I have created a line graph based on dates and the values associated with those dates. However, it is inserting dates into a graph which I do not want. The dates run in chronological order, I only ...
0
votes
0answers
14 views

Label distribution and scaling in Numbers

I'm currently working in OS X Numbers on a document with two columns and 1078 rows. Using this data, I have constructed a simple 2D line graph which I am fairly happy with. The issue that I'm having ...
0
votes
1answer
23 views

A chart where the line between points does not interpolate

I have an Excel spreadsheet showing the balance of a bank account over time. Each data-point is the balance of the account immediately after a transaction (so there might be several per day, with the ...
1
vote
1answer
74 views

How to draw an excel chart from two columns?

Consider the following table: 1970 - 4705 1980 - 4771 1990 - 4998 2000 - 5181 2001 - 5195 2002 - 5205 The left number is x, the right is f(x). (The numbers are in separate excel columns) I need to ...
0
votes
0answers
8 views

How do I configure the plot area to display my entire series of data?

The simplest way to describe my question is to view this image: When I click on the series (i.e. the bars, you can see that the "shadows" of the non displayed bars are displayed outside the plot ...
0
votes
1answer
15 views

Excel Chart Object without source data in Word going back to Excel

I have an Excel object chart in word. The chart is a line graph. The data is there because when I mouse over the line, I see each individual x and y value. However, the word file chart was sent to me. ...
2
votes
1answer
74 views

Excel: How to create (truly) blank cells from formula so that they wont show up in a chart?

I have a table where track data on a daily base, compare it to a daily target I have set, calculate the gap between the two and display the data on a line chart. The data has 4 columns: A. Date (from ...
0
votes
0answers
51 views

Excel 2010 Chart Not Printing To Size

I have an excel spreadsheet that I am trying to print with a chart located in it. The chart is properly sized in the spreadsheet and looks fine when viewing it in the editor. When I go to print the ...
1
vote
1answer
26 views

Can I produce an area chart specifying x and y coordinates

I'm trying to make an area chart in Excel in which I can specify not only the Y coordinates of each point in the series, but the x coordinate also, but it seems to not want me to specify anything like ...
1
vote
2answers
65 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 ...
0
votes
1answer
93 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
1answer
61 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
0answers
113 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
2answers
29 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
1answer
26 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
1answer
165 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
2answers
56 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
1answer
68 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
1answer
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
1answer
36 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
15 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
40 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
22 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
30 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
90 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
35 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
27 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
151 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
2answers
265 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
28 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
30 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
105 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
48 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
57 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
0answers
29 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
1answer
25 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
144 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
53 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
146 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
55 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
120 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
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
1answer
52 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 ...