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

learn more… | top users | synonyms (3)

3
votes
0answers
550 views

Create line graph with embedded horizontal histogram

How do I create these kinds of graphs: with the horizontal histogram counting the number of times the left graphs go through a certain range? I have access to Microsoft Excel and R.
2
votes
0answers
234 views

Add custom error bars to multiple series in one graph

I have my data in a csv file like below, except with more columns and rows Mean values 61 43 Sample 1 0.009 0.059 Sample 2 0.108 0.099 Sample 3 0.043 0.038 ...
2
votes
0answers
52 views

How to attach a note to a specific date in a dynamic graph?

I have a graph that I update every month with new data. I want to annotate some comments to relevant days inside the graph, and when I update it, they stay fixed to that days. Now, I draw this notes ...
2
votes
0answers
83 views

Excel 2010 / Outlook 2010 - Changing the size(with precise numbers) of a chart exported from Excel to Outlook?

If I export(copy&paste) charts from Excel 2010 to Outlook 2010, I'm not presented with a "size proprieties" option when trying to resize them. Since I have multiple chart to resize for each ...
2
votes
0answers
67 views

Extract data from graph with curve as axis

I need to get data from a pretty simple yet not really common type of plot (graph). If you take a look at this image, you will notice that the Y axis is irrelevant and that curve has to take its ...
2
votes
0answers
184 views

MS Project 10 & 13 - Creating Custom Gantt Chart for Resource Allocation

I have created a very basic setup to better monitor staffing and scheduling decisions for my firm. Essentially, I create one task for each new project and assign the resources that will work on that ...
1
vote
0answers
21 views

How to use Excel 2010 VBA to set series line color, marker fill, and marker line color

I am trying to write an Excel 2010 VBA subroutine to format charts according to a predefined (i.e., defined by me) standard. The particular attributes that I want to be able to set are merely the ...
1
vote
0answers
17 views

how to plot on 2 axis with 3 data sets

I have a graph about tracking investment value. It has 2 Y axis scales. First data set displays fine (left Y axis scale) Second data set displays fine (right Y axis scale) However when I try to ...
1
vote
0answers
49 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 ...
1
vote
0answers
44 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 ...
1
vote
0answers
111 views

How to chart time of day in Google Spreadsheet with midnight crossover?

I'm struggling with the best way to chart a series of times in Google Spreadsheets that involves a midnight crossover. The data in question is a graph of a bedtime, when the time to bed is after ...
1
vote
0answers
155 views

Plotting timedata in gnuplot

I have a log file (auth.log) where non-relevant lines has been removed. I wish to aggregate lines per hour/day into the plot, meaning that each line that is within the same hour or day is aggregated ...
1
vote
0answers
159 views

LO Calc: Why are data labels placement options greyed out?

When creating pie charts I like to add the values of the individual slices to the chart. LO Calc allows you to do this ('Add data labels') By default Calc places these values in the center of the ...
1
vote
0answers
368 views

Excel chart axis values are doubling up along the axis

Excel chart axis values are doubling up along the axis - how do I stop this happening? It is in both the primary and secondary scales. eg the axis shows 18, 20, 20, 22, 22, 24, 24, 25
1
vote
0answers
359 views

How can I change the default font size that is set on charts in a PowerPoint template?

As the title says I'm interested in knowing how I can change the default font size that is set on charts in a specific PowerPoint template. I'm not interested in using chart-templates for this, since ...
1
vote
0answers
68 views

Finding more flexible 'chart-to-code' software

I'm looking for suggestions of a new software development tool for any object-oriented development language e.g. C++ , C# , VB etc. Here's some examples of some software coding: I'm looking for ...
1
vote
0answers
230 views

Gantt chart drawing tool

I need a Gantt chart drawing tool but on timeline I need my custom units (e.q. from 0 to 3000), not days or years. What tool alows to do that? Edit: Finally I have found no such tools. I had to make ...
1
vote
0answers
381 views

How to plot this in iwork-numbers

I have an array of data like this 0,1 0,56 0,4 0,57 0,6 0,006 0,34 0,46 ... I have another array of data that classifies the data above in categories like this: from 0,1 to 0,5 category A from ...
0
votes
0answers
19 views

Using Chart BeforeDoubleClick with a chart object in worksheet

I am trying to get a macro to work on a chart in a worksheet using the Chart.BeforeDoubleClick event. I have been able to use BeforeDoubleClick event (without the use of class modules) in a ...
0
votes
0answers
13 views

Formatting a chart with many data points for a small display area

In Excel 2013, I need to display a chart with dates on the X axis and errors (already computed) on the Y axis. The problem is that I have 916 data points taken every six hours spanning approximately ...
0
votes
0answers
19 views

excel chart data labels failing to apply to all series

if I have a multiple series chart (pivot chart to be exact, can be line or bar) and I select (from the ribbon) layout data labels more data label options... then it automatically slaps ...
0
votes
0answers
11 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
45 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
0answers
24 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
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
0answers
55 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 ...
0
votes
0answers
211 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 ...
0
votes
0answers
22 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
0answers
157 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
54 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
0answers
30 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 ...
0
votes
0answers
212 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
69 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 ...
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 ...
0
votes
0answers
141 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
132 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 ...
0
votes
0answers
90 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
0answers
1k 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
0answers
81 views

Excel chart copying whole sheet into a new workbook - references to hidden rows are copied as absolute link

When in Excel 2013 I copy and rename whole sheet containing a chart into a new workbook, my references to series value ranges, axis labels etc., that have data in hidden rows, are not copied as ...
0
votes
0answers
223 views

Excel 2010 Pivot Pie Chart on Results Column instead of first column

my Pivot Pie Chart always displays the splits of the first column of the Pivot table. I´d like to use slicers to chose the Periods in the pivot table and then would like the Pie chart to adjust to ...
0
votes
0answers
141 views

how can i capture a flash object thats displayed by the browser but the swf file is kind of protected, like on scribd

i want to download a stock's intraday price chart. its a flash object. dont know whether its protected in such a manner as to not allow it to be saved on to the disks of end users(like certain files ...
0
votes
0answers
50 views

The Specified Dimesion is not valid for current chart type

I am trying to open a file into which I will copy the data from the previous file but I am getting an error while opening the other file. Here is my code Dim WSC, WSD As String Dim Filter As String, ...
0
votes
0answers
115 views

Trendline not printing

I have many pages with similar graphs and data tables to print. And there is one page that does not print the trendline in the graph. I reloaded the file and tried printing it which worked out, then i ...
0
votes
0answers
268 views

Excel VBA updating graph data

I have several charts referencing off one particular dataset. Each chart has a different number of series. Each series refer to one particular row of the dataset for a certain number of columns (ie. ...
0
votes
0answers
274 views

How can I create a compound bubble and pie chart?

I'm looking for a way to create a compound bubble and pie chart likes this one: I know that ManyEyes could do it, but I don't want to upload my dataset to the public. How can I accomplish this?
0
votes
0answers
325 views

Excel Radar chart to visualize data

I have a set of data with which I want to produce a Radar chart for easy comparison. This is just like an inventory list with A,B and C as the products list, I want to achieve the following : ...
0
votes
0answers
182 views

Highlighting values in Excel pivot table or chart

Excel can prepare pivot charts and tables based on tabular data on an Excel sheet. I am looking for a way to highlight sections of the pivot chart or table to easily see where a specific single ...
0
votes
0answers
76 views

Excel 2010, changing on its own

Excel 2010 has began changing my chart tab names from the ones that I set, back to "chart 1" "chart 2", etc. I went through and changed them all to what I had set again, and the next day they were ...
0
votes
0answers
66 views

Programs for reading data off interactive web charts

This question is in the same vein as this one: Program for reading data off scanned graphs Recently more and more interactive charts show up on the Net. Have a look at the following one: ...
0
votes
0answers
187 views

How to apply Excel formula to datapoints for chart *without* helper column?

in Excel (2007 or newer) is there an easy way to apply any Excel formula on a set of datapoints before drawing a line/box/... on the chart, without using a helper column to do so? (This is a ...