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

learn more… | top users | synonyms (3)

1
vote
2answers
2k views

Splitting data into multiple series' in Excel Graph

I have data from a csv formatted as such: StartTime EndTime Duration Type --------- ------- -------- ---- 43:04.7 43:06.9 2200 long 43:06.9 43:08.7 1825 middle 43:08.7 ...
1
vote
1answer
1k views

Math Round multiple cells, generate integers and histogram integer values

I want your help for the following points: How generate integer values using Data menu > Data Analysis > Random Number Generation or (if this action can't be done) how round multiple cells in same ...
1
vote
2answers
3k views

Excel: How to create a chart that automatically scales the axis

I have 2 columns with values, say A and B which values I want to use as X and Y axes values correspondingly. The values are the following: A: 412 684 944 2009 9601 B: 7813,4 10377,6 11138,8 16216 ...
1
vote
2answers
408 views

Grapher: Edit Equations Without GUI

I'm trying to edit the equation of a Grapher file without opening the Grapher UI. I've gotten as far as knowing that I need a hex editor to do this. I can't, however, find my equation in that file to ...
1
vote
2answers
7k views

Excel - Chart that sums the values in multiple rows for each series

Suppose I have a spread sheet that looks something like this... Now, I'd like to create a column chart that has 3 series, one for each country. Then, I want series for each category, but I want to ...
1
vote
2answers
2k views

Excel 2010, Consolidating Category Axis in Pie Chart

I am working on a very basic "home budget" spreadsheet, to quickly see: A) how much money is left after the bills are paid and B) what % of withdrawals are going to what categories of expenses. I ...
1
vote
2answers
1k views

Excel charts in PowerPoint 2007 are not editable by PowerPoint 2003

I'm trying to save a PowerPoint 2007 presentation which includes a chart copied from an Excel 2007 sheet in 97-2003 format but the chart is no longer editable by Office 2003 since it's automatically ...
1
vote
1answer
56 views

low-latency charting?

Need to deliver real-time charts (mostly bar and line charts) and wondering if a fast library can help. I guess that C is mandatory for speed and I would favor frame-buffer drawing (rather than a ...
1
vote
2answers
801 views

How to get scrolling plot in Linux (using command-line tools)?

Supposing I have a program that prints lines with data periodically, how can I turn then info them into graphical plot that updates itself each time new line available? $ ./prog 10 44 20 66 30 55 40 ...
1
vote
1answer
7k views

Why can't I add a trendline to a chart in Excel 2007?

I created a really simple chart based on 2 columns (date and numeric value). I click on the chart, go to Chart Tools/Layout. The Trendline drop down is greyed out. What am I missing?
1
vote
2answers
59 views

Is there a web site that allows you to draw an ascii chart with boxes and arrows easily?

Ascii drawings and charts are a useful way of documenting software and can be included directly in source files near the code they document. I'm looking for an online tool to draw them and be able to ...
1
vote
2answers
30 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 ...
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 ...
1
vote
1answer
18 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
157 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
3k 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
1answer
158 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
26 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 ... ...
1
vote
1answer
187 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 ...
1
vote
2answers
60 views

Excel plot digitizer [closed]

Is there any plot digitizer usable in Excel? I have discrete points (values X and Y) and I have to create graph from these - Excel can create the "mean curve" (I am sorry, I am not a native speaker so ...
1
vote
2answers
65 views

How can I use the row number in an Excel chart?

I have an Excel table which is simply one column of dates. Each date has a distinct value, and they are already sorted. Something like: 5/29/2011 6/21/2011 6/26/2011 7/1/2011 7/3/2011 ...
1
vote
1answer
305 views

Changing the units on the x-axis in a LibreOffice Calc chart

I've used the LibreOffice chart wizard to make a chart, and I would like the x-values to be different to the default of 1,2,3... (in this case, 500,1000,...). How can I do this?
1
vote
2answers
345 views

In Visio, how do I create a chart with coordinates throughtout time

I have these data (from MSSQL, that I converted into Access/Excel) on a moving object in a defined space x y time 0 0 07/04/2014 08:48:07 5 5 07/04/2014 16:35:25 6 4 ...
1
vote
1answer
91 views

Two problems with Excel graphing

See the following figure I have two problems with Excel 2013, I am not sure how to solve these: 1) The axis title overlaps the data values on all my axes. From the figure, I am unable to change ...
1
vote
1answer
788 views

Excel custom axis label

I'm having troubles with some charts I'm creating using Excel. Some of the values I'm plotting are too big (264) to be labeled in the axis. Due to this, Excel automatically puts them in scientific ...
1
vote
1answer
415 views

Chart Categories: How To Combine X-Axis Categories

The Task I'm putting together a dashboard wherein I'm building several charts. I've attempted to use a pivot chart (2D line chart) to pull data from two different pivots (with the same source data). ...
1
vote
1answer
489 views

Grouping Excel charts in a Word document

I have some Excel charts that I've pasted into Word, and I would like to group them together so they move as a unit as I'm moving text around. Currently, they look like this: (forgive the rough ...
1
vote
2answers
212 views

Average using Elapsed Time processing a number of docs

I process documents and want to get a formula showing the average time to process each document. Here's my data: number of docs processed (column G) start date/time (H) end date/time (I) elapsed ...
1
vote
1answer
1k views

Excel error bars based not on the graph data, but a separate set of error measurement data

I have several data sets, each of which includes several tests. Each test contains several temperature samples at different locations. For each data set, I have an average of the different tests for ...
1
vote
3answers
6k views

Plot cumulative data in Excel

Is it possible to plot data in excel without having to define the function of the data in an extra column? Think of this simplified example: There are two columns with numbers A and B. Is it ...
1
vote
1answer
5k views

Excel 2010 chart does not show x axis value

In Excel 2010, chart data series don't seem to show the X axis value. When you put your cursor on a certain data point, it shows "Series(Y axis value)"/ "Point(X axis value)"/ and "Value". The X axis ...
1
vote
1answer
720 views

pivotslicer connected to multiple pivotcharts

Can I connect my pivotslicer to multiple pivotcharts, but on different category levels, so If for example I have a categorytree that goes: Department --> Section If I choose "Section A" Then I can ...
1
vote
1answer
3k 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
vote
1answer
2k views

Lines over data in Excel 2007 Scatter Graph

I have some data that needs plotting in a scatter graph in Excel 2007. However, I need another line (for some arbitrary function - e.g. using trendline will not work) that is represented by a second ...
1
vote
1answer
457 views

Excel 2007: plot data points not on an axis/ force linear x-incrementation without altering integrity of non-linear data

In Excel, how does one go about plotting points that don't have an x component that is an x-axis label? For example, in my graph, the x-components are derived from the cosine function and aren't ...
1
vote
1answer
669 views

Linked Excel 2010 Charts Won't Show Field Codes in Word 2010 - What am I doing wrong?

Thank you for reading. I hope this is something simple I am overlooking. Synopsis: I have a Word doc containing linked charts from a single Excel source. They are docx and xlsx files created in Word ...
1
vote
2answers
1k views

Creating a graph with a “peak” value (x-axis from 0 to 100 to 0)

I want to create a graph whose x-axis will start from 0, peak at 100, and then return to 0 - all from left to right. An example is attached. How do I do this? Data: Applied Voltage Capacitance ...
1
vote
3answers
9k views

How do I get a chart in Excel to add new data series automatically?

I am working on some charts for financial reporting. One of them shows some values for individual companies. I will need to add new companies on a monthly basis, and would like the diagram to ...
1
vote
3answers
2k views

Real-time graphing application for SQL data

I am looking for a free data graphing application that can pull data from MySQL and display it on a trend graph without any programming. It should use a GUI to select the data to be plotted, start ...
1
vote
2answers
2k views

How to generate a round-numbers graph in Excel?

folks! Now, I have an Excel file with measurements I made of some color patches (I work at a Press company), with a device called spectrophotometer. Here it is: ...
1
vote
1answer
346 views

Can you create dynamic named series for a chart?

I need a column chart which trends 6 month(I have this covered) but stretches rows based on values in the data set. I could hook the chart to the pivot BUT I need to summarize all values over a count ...
1
vote
1answer
5k views

Excel: Charting date, time elapsed, and another value

I'm trying to chart growth in our nightly backups. The three values I'm using are the date of the backup, the backup job size in bytes, and the time the job took to completely in hh:mm:ss. Using ...
1
vote
1answer
63 views

Downloadable map data usable in applications [closed]

I wish to create a small pathfinder application with maps. Where can I download navigation European map data and find documentation about their formats?
1
vote
1answer
1k views

Plot disproportionate values in single graph with Excel

I have multiple series of data that are on different scales and I would like to graph all of them in the same line chart based on percentage, but I want to label the points with the actual values. One ...
1
vote
2answers
328 views

Desktop software for data analysis, like Business Objects “Lite”

My data set is sourced from ~100k users, with a few million records scattered over a dozen tables. Just too big for Excel, but not quite a data warehouse. It's sourced from a web-sites user base and ...
1
vote
1answer
626 views

Generate a point chart from XML data, possibly with Excel?

I would like to generate some point chart from XML data. The data should be grouped using color by its "id" attribute. The position is stored in "x" and "y". What software should I use? I tried Excel ...
1
vote
1answer
798 views

Excel Chart not displaying X Axis

I've got a chart in a spreadsheet in Excel 2010 which is using A chart = "Stacked Column in 3-D" I have defined the Horizontal (Category) Axis Label in the Select Data Source window and it is ...
1
vote
1answer
963 views

Excel 2007 bar chart auto axis

I am creating a bar chart with values ranging from 100 to 100,000. I keep the X axis as auto scaling allowing me to change the starting point. From what I understand, if two bars variance is greater ...
1
vote
1answer
882 views

Excel graph: turn stacked bar chart into part bullet chart

I've a simple data file that has one column of actuals and another of target against categories. I would like to turn the TARGET figure into a 'Bullet marker'. I've seen it done on other graphs but ...
1
vote
1answer
394 views

Tools to plot time-series data

I have a time-series dataset that looks like this (a few thousands of entries spanning for a couple of years): timestamp <TAB> items_added <TAB> items_removed For example: 1286016527 ...