Graphs, charts and other graphical methods for showing data and their relationships.

learn more… | top users | synonyms (3)

1
vote
1answer
3k views

Time units and automatic formatting of the y-axis in Excel

I have a chart with time values on the vertical (Y) axis. As the values can change a lot the formatting of the axis minor and major units is automatic. The problem is that Excel chooses values which ...
0
votes
0answers
86 views

Place multiple columns onto one line [duplicate]

Let's say I have a table in a spreadsheet that works like a calendar: Jan Fev Mar ... 1 5 7 1 2 3 4 9 3 8 3 1 4 2 9 0 5 2 1 2 ... And so on... I need to make a chart ...
1
vote
1answer
413 views

Label's format in barchart different from the corresponding cell

I have stacked bar chart. In the label's format I checked "linked to source". Now in the datacell,l I have this custom format "[>999999]#.##0,00.." M$";[>999]#.##0,00." k$";#0,00$". The problem is ...
0
votes
1answer
40 views

Blank Excel PivotChart

My Pivot Table has everything I want however,I want my chart to show how many Issues have the status of severe, mild, or moderate. But instead it is blank. What should I do?
2
votes
1answer
997 views

How do you set a variable Y-axis min/max?

I have a colleague who creates lots of charts. He wants the min/max of the Y-axis of a bar chart to reflect the min/max within a range in Column "A" of an Excel spreadsheet. The min/max will change ...
1
vote
1answer
617 views

Excel 2003 charts not looking right in 2007

I'm not exactly sure this goes here but I don't know where else to look for help. I have some Excel files containing charts made with Excel 2003. When I open the file in Excel 2007 and save it (non ...
0
votes
4answers
9k views

Set automatic axis limits for bar chart without defaulting to zero

I am building a bar chart in Excel with data values ranging from, e.g., 10 to 20. I want the x-axis limits to be automatic, but although the right limit (near 20) works correctly, the left limit ...
1
vote
3answers
11k 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 ...
2
votes
1answer
562 views

excel chart dynamic range based on values

I'm trying to create a chart that auto updates itself from a data provided. The range of the chart is always fixed/locked. The issue I'm facing is that when a value for a certain month is 0, I want it ...
1
vote
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
386 views

Creating a pie-chart (of how many times a number is repeated) in Excel

I am trying to create a pie chart in Excel, but cannot figure out how to get it to work. I have a list (column) of numbers and the pie-chart needs to show how many times numbers are repeated (or how ...
0
votes
0answers
248 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 ...
3
votes
2answers
16k 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
3answers
2k 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
185 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 ...
0
votes
1answer
188 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 ...
0
votes
1answer
567 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
796 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 ...
0
votes
1answer
235 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
226 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
164 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
78 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 ...
0
votes
1answer
1k 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
votes
1answer
1k 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
357 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
780 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
2k 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
2answers
573 views

Apart from visually inspecting the graph, is there a way of calculating when a trend line will cross another series?

Is there a way to find the point of intersection of a trend line and another series on a chart in Excel? The other series may be another trend line or just the interpolated line drawn by Excel.
4
votes
2answers
687 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% ...
1
vote
2answers
3k 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 ...
1
vote
0answers
452 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
2
votes
1answer
1k 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 ...
0
votes
2answers
612 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 ...
3
votes
3answers
3k views

Excel trendline accuracy

This is a problem I have every once in a while, and it annoys me tremendously, beacuse I have always to recheck every trendline I get. An example: r L (mm) 30,00 97,0 60,00 103,2 ...
1
vote
0answers
68 views

Finding more flexible 'chart-to-code' software

I'm looking for suggestions of a new software development tool for any object-oriented development language e.g. C++ , C# , VB etc. Here's some examples of some software coding: I'm looking for ...
1
vote
1answer
967 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 ...
-1
votes
1answer
73 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
728 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
1k 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
6k 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 ...
0
votes
1answer
593 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
203 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 ...
3
votes
1answer
748 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 ...
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 ...
1
vote
1answer
1k 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
399 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
2answers
550 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 ...
2
votes
1answer
110 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 ...
1
vote
1answer
805 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 ...
0
votes
1answer
4k 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 ...