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

**0**

votes

**0**answers

74 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 ...

**-1**

votes

**1**answer

762 views

### How to make LibreOffice Calc to connect points in a holed series chart with lines?

I've got a time series data table with one function (row) value available for every month and the second for every 3rd month (every quarter), having holes (empty cell values) for every 2nd and 1st ...

**1**

vote

**1**answer

248 views

### Excel - Create the same Charts Monthly

I've got a workbook with a table that has the months across the top. Each month, another month column will be added and the data for that month will be filled in.
For each month, I want to create ...

**3**

votes

**1**answer

503 views

### Print an organizational chart to PDF from JSON data?

I've been searching for a few days and haven't found quite what I need yet.
I've got a tool I'm working on that displays a person in a sort of visual hierarchy of the company (from the CEO down the ...

**1**

vote

**1**answer

1k views

### How to create excel line charts with irregular scales

I am trying to create a line graph, The vertical axis is an irregular scale - 1,1c,1b,1a,2,2c,2b,2a and so on.
Here is the data in chart format
I am having trouble representing this data in the ...

**0**

votes

**2**answers

4k 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
...

**2**

votes

**1**answer

139 views

### Custom area graph in Excel (or google spreadsheet)

I am trying to visualize my loans with area graph and have some additional needs/wishes.
For example - this is my data (made up):
house car mower vacation
diners ...

**1**

vote

**1**answer

513 views

### How can I break external links in PowerPoint 2007 but keep the charts editable (not images)?

I have created a few charts in an Excel file and then pasted them as links into PowerPoint (PPT). Whenever I update the excel file, PPT updates automatically.
However when I break the links, the ...

**1**

vote

**3**answers

7k 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

**0**answers

240 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

**0**

votes

**0**answers

60 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:
...

**1**

vote

**2**answers

1k 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:
...

**0**

votes

**1**answer

579 views

### X axis on Time-Based data

I have a series of 24 hr. data, taken about once per hour. I wish to plot the values against time. On day 1 the 10:00 data was taken at 10:10, on day 2 the data was taken at 9:58. I do not want both ...

**1**

vote

**2**answers

2k views

### Change the Point Color in chart excel VBA

I'm trying to the get the points from a chart in excel vba? I made a chart of student marks in excel, and I want to put a condition i.e if marks on chart are greater then 90 then the point color ...

**0**

votes

**2**answers

410 views

### Date axis with a partial year

I have a line chart with data spanning from February 2002 to today. At the moment, the date axis looks like this:
Is there a way to have the first date be Feb-02 (no change), but the next one be ...

**2**

votes

**3**answers

221 views

### What tool to use to create a chart like this one? [closed]

Which tool can you recommend to draw such a diagram:
I have tried Excel, but it is not really straight forward.

**-1**

votes

**1**answer

67 views

### Is there a tool to get data from a pie chart instead of the other way around?

I'm looking for a tool that helps me creating an investment portfolio. I'd like to decide the percentages first, and then the tool would output quantities. Also, percentages should be hierarchical. ...

**0**

votes

**1**answer

129 views

### Create Excel pie chart from choice placement

I have a table like the following :
Choice 1 Choice 2 Choice 3
Person A 3 2 1
Person B 1 2 3
...

**3**

votes

**2**answers

2k views

### How can I plot a grouped histogram with LibreOffice Calc?

I would like to produce a grouped categorical histogram with LibreOffice Calc.
With grouped I mean an histogram with N columns instead of a single one for each category.
Something like this:
Any ...

**1**

vote

**1**answer

565 views

### Excel - set data range for multiple charts

I have a 'dashboard' of weekly stats - with week numbers in the columns across the top, and about 70 metrics in the rows.
I want to create around 20 charts from these different metrics, but always ...

**0**

votes

**4**answers

2k views

### Good (preferably free), easy to use, attractive flowchart software [closed]

While there is no shortage of awesome concept mapping or mindmapping software, I'm left rather cold by the offerings of flowchart related software or apps available.
I'm looking for something that ...

**0**

votes

**1**answer

488 views

### Windows. Active X objects. Excel Chart

i need to find Excel active X object mschart.ocx or mschrt20.ocx.
Where are they laying?
Thanks!
P.S:
Am i right, that they can help me to use active x chart: msdn
Thanks!

**1**

vote

**1**answer

738 views

### Organization chart using Active Directory

Is there any tool which can depict Organization chart using data pulled from Active Directory.
I am looking for portable thick client which can run on Windows.

**1**

vote

**1**answer

3k views

### Excel chart axis does not depict the data correctly

I have a problem with an Excel chart.
I have
a primary axis (two series), showing volumes in millions
a secondary axis showing percentages (one series)
The primary axis seems to be adding the ...

**2**

votes

**1**answer

626 views

### Windows programs to create timeline charts?

I would like to create a chart for my source control depicting the trunk and all the branches, with various details, like creation date, merge date, created revision, merge revision, close revision ...

**1**

vote

**1**answer

399 views

### Free/opensource application for charting stock prices?

I am looking for a free or FOSS software application for SIMPLY charting stock prices. I am not interested in any of the other nonsense typically bundled with such packages (technical analysis, back ...

**0**

votes

**0**answers

160 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 ...

**2**

votes

**1**answer

1k views

### Can I crop an excel chart to remove part of the chart?

I followed some instructions to create a speedometer chart (pie chart with a scatter line chart on top).
However, this solution leaves a large blank space below the chart; 50% of the chart's space is ...

**0**

votes

**1**answer

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 ...

**3**

votes

**1**answer

564 views

### Free or Open Solution for Storing and Charting CSV data

I'm presently storing CSV files, combining them, opening them in open office, creating pivot tables and then generating charts from the spreadsheet.
I've looked at OOBase, but appending csv files to ...

**0**

votes

**1**answer

570 views

### Emphasize 100% axis line in Excel

I have a bar chart of %s, where some of the values are over 100%. I have the gridlines set at 20%, but would like an extra emphasis on 100% to make the better values stand up.

**1**

vote

**0**answers

277 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

**2**answers

353 views

### Please recommend software to draw sequence diagrams [closed]

I have tried Dia, but it does not seem to provide a convenient set. Particularly, I cannot find the self-directed circle in Dia.
I drew the illustration in Word, but it is not very convenient. (The ...

**0**

votes

**1**answer

79 views

### Comment a remarkable point in a graphic

I have a graphic like this one, based on dates/values:
Some points on the graphic represent special events, and I'd like to associate them with a comment, like: "Called the manager", "Strike", ... ...

**2**

votes

**1**answer

99 views

### Can I use 2 different Columns of Data for the same axis & same series in Excel

I have a simple dataset in Excel showing Players, Win Count & Win %
I'd like on my Bar Chart to keep the % on the Vertical Axis like it currently...
But I'd also like to put the Win Count on ...

**0**

votes

**1**answer

2k views

### Excel chart does not show all line feeds

I'm trying to set up an Excel chart. I've tried to enter 6 line feeds. I have followed the steps correctly, but on the graph it only shows 5 lines. On the right hand side listing of feeds it shows the ...

**4**

votes

**2**answers

461 views

### How can I split the wedges of a pie chart to show extra information per wedge in consecutive rings?

I'm plotting disk partitioning and available space.
I have a pie chart showing the partitioning: e.g. 30% /, 70% /home.
In the second ring I want to show that 90% / is full, 10% of / is empty. 10% ...

**2**

votes

**1**answer

4k views

### How do I get data or percentage displayed in libreoffice pie chart?

I need to get a pie-chart with values - can libreoffice do it?

**0**

votes

**1**answer

2k 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

**1**answer

373 views

### Boxplots in Excel

Excel does not come with boxplot charts.
What is the best technique to simulate boxplot charts in Excel?
I'm interested to
draw horizontal and vertical charts
display the mean in addition to the ...

**0**

votes

**1**answer

420 views

### On a bar chart showing value gains in time frame, what is the easiest way to show losses?

I have a chart as on image below:
The red part of these charts are loses – values which should be subtracted from the overall amount. Is there any way that I can both show them on the chart and ...

**3**

votes

**2**answers

12k views

### Excel - stacked bar charts with two pairs of 'overlaps'

I'm trying to do some 'stacked' bar charts in Excel 2010 - here's a close psuedo example.
Team Buying target Buying result Selling target Selling result
Team A 80% 50% 70% 90%
...

**1**

vote

**1**answer

1k views

### Bar chart in Excel 2010 with values over maximum

How can I make a chart like this in Excel 2010?
Image from: EPA.gov
I have data where two out of 20 values are disproportionately large. In order to create a useful chart I'd like to cut out a ...

**0**

votes

**1**answer

95 views

### How to chart different shifts run times in Excel 2003

I have the following as an example.
Date Duration Shift
4-Dec 60 1
4-Dec 40 2
5-Dec 45 1
5-Dec 55 2
5-Dec 30 3
I am trying to map these ...

**1**

vote

**3**answers

6k views

### Changing data series line weights in Excel chart (many at once)

Is there a way to edit the weight of all lines at once on an Excel line chart?
I have a graph with about 50 data series on it, and it's too much to go through all of them and change the weights ...

**0**

votes

**1**answer

1k views

### How do I create this clustered column chart in Excel?

I have a data sheet split into three tables (one for each level). Within each table, there are four columns based on the answer (positive, neutral, negative, or N/A) and then there are six rows, each ...

**3**

votes

**2**answers

247 views

### Simplest Automated Analysis and Chart Generation Tool?

Are there any products that can take a CSV of info, and quickly generate commonly-asked for info? I'm wondering if there's any way easier than pulling this into Excel or Matlab and manually doing all ...

**2**

votes

**1**answer

870 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 ...

**0**

votes

**1**answer

375 views

### Excel scatter graph line only “connects data points with line” even with #N/A in source cells?

Excel scatter graph line only "connects data points with line" even with #N/A in the source cells. I have tried using different scatter graph line types but all interpolate the data over the ranges ...

**1**

vote

**1**answer

2k views

### Creating a 2D chart in excel with 2 Y-axes - one stacked, one non-stacked

I'm looking to create a 2D line-chart in Excel 2007.
It will have 2 Y-axes. The X axis will be dates.
There will be 5 series. I want 3 of the series to be stacked and use
one Y-axis, and the ...