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

learn more… | top users | synonyms (1)

0
votes
0answers
149 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
3answers
1k views

Putting a line feed in a string built in an excel formula in a data label

I need to construct a data label in an excel chart using a formula building the string from two cells with a line break between them. This would work in a cell formula: =A1 & CHAR(10) & B1 ...
0
votes
1answer
159 views

Excel X axis label

In Excel, I want the value of the data marker displayed at the right edge of the data marker. Ex: an amount representing 0-10 is graphed, and the 10 on the X axis is on the right edge of the column ...
2
votes
0answers
567 views

How to make a LibreOffice Calc XY (scatter) plot with named dots?

I have a simple XY scatter plot made from a 2-column spreadsheet. When I hover over a dot, I can see the ID of the dot (e.g. "Data point 8456"). I would like to know if I could have the content of a ...
2
votes
1answer
218 views

Manually “draw” data for chart, output to CSV

I need a service that will allow me to draw a chart line by hand and generate data points for what I drew. This might sound crazy, but I need some data (preferably in CSV output) that will only ...
2
votes
2answers
8k views

How to rotate text in axis category labels of Pivot Chart in Excel 2007?

I'm using a pivot chart in Excel to display data. My problem is: I can not influence the orientation of the text in the "axis" (don't know how to call it correctly, I'm sorry). As an example: In the ...
0
votes
1answer
370 views

Pull Data from Pivot Table to Grid on Different Worksheet

I am trying to make an Excel Workbook that contains the statistics of an XBox Tournament that our office is doing. Winner of the whole Tournament wins the XBox! It's fairly simple rules. Everyone will ...
1
vote
1answer
656 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 ...
0
votes
1answer
133 views

How to get average of multiple time series

I have few computers running. I want to get the average CPU usage of these computers and plot it as a graph. So I've collected CPU usage in regular intervals in these machines. So for each computer I ...
3
votes
3answers
5k views

Excel chart show year intervals on axis

ON the x-axis of a chart in Excel I would like to show the separates when years change and put the year in the middle of the interval. How can I do that? See the below image for an example of what I ...
0
votes
1answer
157 views

How do I select a blocked chart in a Excel 2010 chart?

How can I select a blocked or protected chart in Excel 2010? When I right-click on the chart, the cursor changes to a circle with a diagonal line within it - a "blocked" sign. I'm doing a study ...
0
votes
1answer
448 views

Making chart from custom data format in Excel 2010

I am defining custom data format via Apache POI. I know I need to use following construction: DataFormat data = this.workbook.createDataFormat(); ...
2
votes
1answer
224 views

Why am I unable to use a named range beginning with “Corona” in Excel charts?

I'm running into a ridiculous problem in Excel 2010 where I cannot seem to use a named range whose name begins with "Corona" in a chart. I've created a new workbook with a simplified version of the ...
3
votes
1answer
14k views

How to create dynamic Scatter Plot/Matrix with labels and categories on both axis in Excel 2010?

Let us consider a following data set: Name | Age | Hair Color ----------------------------- John | Young | Brown Sophie | Old | Blond Adam | Mature| Blond Mark | Teen | Dark Jeremy | ...
2
votes
2answers
3k views

Vertical Histogram in Excel with Conditional Formatting

I'm able to do data bar conditional formatting in Excel 2010, but I can't figure out how to switch the bar axis to make it vertical. Is there any way around this? Can I simulate a vertical histogram ...
0
votes
1answer
173 views

What is the best way to graph this in excel

I have a table in excel with three columns: Name Start Date End Date I want to create a chart with count on the left hand side and date on the bottom to show the count of open item (defines ...
0
votes
1answer
149 views

Excel Line chart multiple related series, colouring

I'm using MS Excel 2010. I have a worksheet that looks like this ---/ 1001 / 1002 / 1003 / 1101 / 1102 / 1201 / 1202 / 1203 / 1204 R2 / ... R3 / ... ... I would like to create a line chart with ...
0
votes
0answers
75 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
1answer
889 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
1answer
301 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
1answer
598 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
1answer
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 ...
1
vote
3answers
7k 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
1answer
149 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
1answer
557 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
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
0answers
307 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
0answers
64 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
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: ...
0
votes
1answer
788 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
2answers
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
2answers
494 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
3answers
243 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
1answer
69 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
139 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
2answers
3k 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
1answer
771 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 ...
2
votes
0answers
481 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.
0
votes
4answers
3k 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
1answer
561 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
1answer
913 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
1answer
4k 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
1answer
831 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
503 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
175 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
2k 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
4k 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
1answer
658 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 ...
1
vote
1answer
818 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.