The charts tag has no wiki summary.
-1
votes
1answer
27 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
1answer
36 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
...
0
votes
0answers
12 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
0answers
14 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
2answers
82 views
Good (preferably free), easy to use, attractive flowchart software
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
1answer
42 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!
0
votes
0answers
46 views
Stacked Column Chart Where Data Is Subset
I have a few rows of data that I want to put into a stacked column chart.
When I create a stacked column chart, it overlays the numbers on top of each other. For example, one row has wait time ...
0
votes
0answers
23 views
Legend Won't Hold Position in Excel 2003 Chart
The legend for my chart will not hold its position. I have manually moved the legend and have used the "format legend" method. After saving with the positioning I want, I go back into the saved ...
1
vote
1answer
101 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.
0
votes
1answer
81 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 ...
1
vote
1answer
100 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
1answer
39 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
0answers
37 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
1answer
132 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
1answer
159 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 ...
1
vote
1answer
62 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
1answer
55 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
0answers
106 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 ...
0
votes
2answers
63 views
Please recommend software to draw sequence diagrams
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 ...
2
votes
1answer
57 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
1answer
155 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
65 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% ...
1
vote
1answer
629 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
253 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
71 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
1answer
56 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
28 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
539 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
131 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
31 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
99 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
437 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
289 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
57 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
185 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
95 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
214 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
432 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
51 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
142 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
620 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
114 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
86 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
240 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
94 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 ...
2
votes
1answer
981 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
180 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
52 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
1k 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
120 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 ...
