The charts tag has no wiki summary.
0
votes
1answer
27 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 ...
0
votes
0answers
22 views
How to splitting wedges of pie chart to show extra info per wedge in consecutive rings?
I'm plotting disk partitioning and available space.
I have 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% ...
0
votes
1answer
373 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
1answer
78 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
34 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
0answers
20 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 ...
0
votes
0answers
15 views
Excel Chart - Unable to input source data from 1 out of every 7 rows in my sheet
I am trying to create a chart to show weekly data but my spreadsheet is set up to show one row (with a total for the week) and then additional rows underneath displaying the daily info. I'm trying to ...
1
vote
2answers
84 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%
...
0
votes
1answer
46 views
Excel 2010: Bar chart with values over maximum
How can I make a chart like this in Excel (2010)?
http://www.epa.gov/recovery/images/bar-chart.gif
I have data where 2 out of 20 values are disproportionately large. In order to create a useful ...
0
votes
1answer
12 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 ...
0
votes
0answers
26 views
Quickly create a comparison chart in Powerpoint Mac 2011
Is there a way to quickly create a nice comparison chart simply by checking boxes in powerpoint Mac 2011?
I know I can manually put unicode check and X in and then color it by hand, but this is ...
0
votes
2answers
92 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
1answer
83 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 ...
1
vote
2answers
34 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 ...
1
vote
0answers
77 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
1answer
39 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
1answer
50 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 ...
0
votes
1answer
152 views
Copy chart from Calc spreadsheet to Writer document without linking in Libreoffice?
I've copied a chart in one of my Libreoffice 3.4.3 Calc spreadsheets into a Writer document in Mac OS X 10.6.8. However, I've noticed that the chart in the Writer document is linked to the one in the ...
0
votes
0answers
23 views
“pin” cells from a filtered range in Excel 2003 chart?
I have a chart created by selecting a range from a table filtered by some values.
Now if I change the filtering, the chart changes dynamically.
How do I opt out of this behavior, i.e. fix the cells ...
0
votes
0answers
62 views
Prevent text wrapping in data table (Excel charts)
Is there some way to prevent text wrapping of long headers with no spaces in the data table of a chart?
I was hoping to find a "Shrink to fit" feature, like the one that can be applied to cell ...
1
vote
1answer
198 views
Plot 2d graph in Excel
I have data in three columns, one for the x axis, one for the y axis and one actual data as:
X Y Value
0 0 1,005155
0 1 2,051385
0 2 1,15305
...
1 0 1,112285
1 1 1,48512
1 2 ...
2
votes
2answers
64 views
How can I show a line chart in Excel (or Access) with category lines that ignore missing data?
I'm collecting data for various series (A-G), at sporadic intervals. I want a line chart, with one line for each series, that is connected even if there are intervals where no data was collected for ...
1
vote
1answer
50 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
175 views
How to create a XY (scatter) chart with three columns of data?
I have the following data:
Date Name Value
1/1/2011 FOO 10
1/1/2011 BAR 12
2/1/2011 FOO 16
3/1/2011 BAR 21
5/1/2011 FOO ...
0
votes
1answer
54 views
How to define an organizational hierarchy in Visio 2010?
How do you create the relationships between positions in a Visio 2010 Organizational Chart?
I have created the chart, added several positions to the chart, and now I wish to define which positions ...
1
vote
1answer
213 views
Create a pie chart from distinct values in one column by grouping data in Excel
I have an Excel document containing information from a survey. I want to create a pie chart over location (countries).
How can I make Excel group all the distinct values together and then display ...
0
votes
1answer
110 views
Good chart drawing software? [closed]
Possible Duplicate:
Application to help build diagrams
I'm looking for a program, which I can use to draw good and smooth-looking charts. I would prefer it to be free, but it is another ...
1
vote
1answer
50 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?
2
votes
1answer
543 views
How can I create proportionally-sized pie charts side-by-side in Excel 2007?
I have a pivot table with two sets of data as follows:
2011 2012
Slice A 45 20
Slice B 33 28
Slice C 22 2
I am trying to present two pie charts ...
1
vote
1answer
63 views
Excel distorting markers in scatter plot
I've run into an issue with scatter plots in Excel. For whatever reason, Excel is distorting the appearance of markers on the plot, such that markers within the same series do not look the same. For ...
0
votes
0answers
12 views
charting tool for timeseries with event labels
I need to draw a chart of some timeseries data (i.e. my weight measured each day) overlayed with some continuous events (like week when i was taking some meds or 10 days i took vacation)
So in ...
4
votes
1answer
102 views
What tool was used to create a chart like this? [closed]
I like the way the below chart represents various products and how they work with Team Foundation Server. I would like to create something similar for a project I am working on. Was a chart like this ...
0
votes
1answer
73 views
How can I make a bar chart in OpenOffice Calc where the bars have two different colors to signify two different types of products?
I'm sure most people have seen the Intel vs. AMD charts that places like TomsHardware.com use, but just in case you haven't, here is my chart:
I want the PV bars in black, and the Solar Hot Water ...
1
vote
1answer
114 views
How to 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
4answers
98 views
Best tool for creating organizational charts? [closed]
Possible Duplicate:
Application to help build diagrams
I need to find a Windows tool/software, or an online service, for creating organizational chart for the company I'm employed at.
I ...
0
votes
0answers
21 views
Chart from groupings
Given such a spreadsheet:
col1 | col2 | col3
-----+------+----
alfa | foo | 10
beta | foo | 20
gamma| bar | 12
delta| bar | 42
I'd like to generate a chart grouping values from col2 and ...
2
votes
2answers
54 views
Chart data by month
I've the following data in an excel spreadsheet:
Date (dd/mm/yyyy) Value
----------------- ---------
01/04/2011 123.45
03/04/2011 7234.25
16/05/2011 80.00
...
4
votes
2answers
790 views
Excel: How to display superscript text as data series on chart?
I have a line chart in Excel 2007 that is created from data in the worksheet. It has several series whose titles are displayed in the chart on the right side. The names of the series are of the form ...
1
vote
1answer
83 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 ...
5
votes
2answers
412 views
Excel pie chart: How to combine smaller values in a single “Other” slice?
I have this pie chart in Excel 2010 (based on a pivot table):
I'd like to combine all the values smaller than X% in a single "Other" slice. In previous versions of Excel, it was possible to use the ...
0
votes
2answers
46 views
How do I make the first row of an Excel chart be treated as a heading when it's a number?
Given a data sample like
Prisoner 24601 0.50
Day 1 80 90
Day 2 81 89
Day 3 82 90
Day 4 81 91
What's the easiest way to tell Excel that 24601 and 0.50 are data series names rather ...
2
votes
2answers
467 views
Excel: Bubble chart labels - use 4th dimension?
I've got a dataset that has 4 dimensions - lets say they're the following:
+------------------------------+
| Type | Amnt |Price| Quality |
+-------|------|-----|---------+
| A | 15 | 4.0 | ...
1
vote
2answers
100 views
Is it possible to have a custom data table visible underneath a chart in MS Excel?
I have a column chart with a single series of data to be shown on the chart.
However, I also have another column of data that corresponds to the one being visualized, but instead of charting it, I ...
0
votes
1answer
103 views
excel - how to connect a graph max with original (0,0) point
If I have a spreadsheet that has the following data:
A
0 0
1 2
2 4
3 4
4 6
0-4 X Axis
A is Y Axis
First point is (0,0)
Second Point is (1,2)
Third point is (2,4)
...
1
vote
1answer
299 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
1answer
276 views
Animate Excel Chart
I'm preparing for an Ignite talk and need to figure out how to animate an Excel chart, which will eventually go inside a PowerPoint. I would like to animate the following into a single chart/slide.
...
0
votes
1answer
157 views
How to generate Excel charts show per interval?
I have the following Mathematical function (I am not refer to programming language, just simply Math):
F(X)={ 1/4, X∈(0,1]
5/12, X∈(1,2]
9/12, X∈(2,3]
11/12, X∈(3,4]
}
I want to ...
2
votes
0answers
58 views
How to generate Excel charts show per interval? [closed]
Possible Duplicate:
How to generate Excel charts show per interval ?
I have the following Mathematical function (I am not refer to programming language, just simply Math):
F(X)={ 1/4, ...
2
votes
1answer
59 views
I would like the dates to appear on the X-axis and the colour category to apear on the Y-axis, Excel
There is probably a fairly straight forward answer out there but I can not seem to find a solution online.
I have a table marked up like this (column names are in bold)
audit date | blindness
...
6
votes
2answers
573 views
Excel 2007 - Custom Y-axis values
I am making a basic column chart with a few columns. The only catch is instead of showing numbers as the grid marks, I want to show words like "Very Low" and "Medium".
For example, I have
Data1 = ...
