Help on questions about graphs, charts and other graphical methods to show data.
1
vote
1answer
13 views
Excel 2010 chart does not show x axis value
In Excel 2010, chart data series don't seem to show the X axis value. When you put your cursor on a certain data point, it shows "Series(Y axis value)"/ "Point(X axis value)"/ and "Value". The X axis ...
-1
votes
1answer
32 views
How can I draw the data in Microsoft Excel?
I have the following date in Microsoft Excel.
What I want to do is make the threshold as the x-axis, and each value corresponding to the threshold (i.e; H1, H2, ...etc) be on the y-axis.
So, for ...
1
vote
2answers
72 views
Drawing sample points versus time in Excel
I have a set of data as follow:
As you can see the first column has either R or P, the second column is a measured value, and third one is obviously time.
I need to present this in a chart (I ...
2
votes
1answer
40 views
Multiple bar charts on one axis in excel
So I have a bunch of series laid out like this in excel:
I'd like to have them plotted all on one column chart but with the series separated (i.e. not clustered) so it basically is several column ...
-1
votes
0answers
27 views
Excel graph pulls fine for one user, but adds years to x axis maximum for another
I created a graph that has 6 different data points, with one being placed on the 2 y-axis. All data is based on 12 month period. When I pull the graph up, it looks fine, but when I have a collegue ...
0
votes
2answers
54 views
Excel 2007 Stacked Column Chart Display Subvalues
So I have the following set of values in my excel sheet:
The values on the first column (very low, low, medium, high) are simply socio-economic layer indicators.
As you can see, everything is ...
3
votes
2answers
86 views
Multiple Y-axis labels in Excel 2010 line chart
I have a table containing cycling data. Date, distance, time, calories burned, max heart rate and average heart rate. They all have different value ranges. Excel scales the chart to show the calories ...
1
vote
1answer
50 views
conditional chart ranges in excel
I have a table of data in Excel 2010 that looks something like this (but with hundreds of thousands of rows over multiple days):
I am trying to create a dynamic chart where the x-axis is the ...
0
votes
0answers
31 views
Visio 2010 Organization chart
I'm looking to build an org chart in Visio 2010 by using data from excel. There are many tutorials about this, so this part is pretty easy.
My question is, is there a way to create automatic ...
2
votes
0answers
29 views
MS Project 10 & 13 - Creating Custom Gantt Chart for Resource Allocation
I have created a very basic setup to better monitor staffing and scheduling decisions for my firm. Essentially, I create one task for each new project and assign the resources that will work on that ...
0
votes
1answer
101 views
Optimally positioning pie chart data labels in Excel with VBA
I have a worksheet where I create a pie chart from data from a database. The chart changes based on the data it is displaying so the slices often change size.
I want to display the data labels ...
0
votes
1answer
48 views
What is the best flow diagram if you have multiple processes and projects tied together like so
I have used flow charts in school and in an attempt to create a less generic chart, I figured I will share the processes and data I wish to organize.. see what ideas are available for this complex ...
0
votes
1answer
27 views
Custom Chart Axis
I have an Excel chart whose X-axis values are 5000, 10000, 15000 and so-on but I want them to be like 1,2,3,... i.e. divide them by 5000.
Is there any way I can accomplish this?
2
votes
1answer
141 views
Can I provide RGB hex strings in an Excel worksheet for pie chart colors without using code?
Like user1813558 in his question "Change the pie chart colors" I would like to choose the colors that Excel uses for a pie chart (indeed for any chart) as I need them to be consistent with other data ...
2
votes
1answer
75 views
1/3 octave band chart in Excel?
I want to create a 1/3 octave band chart in Excel 2007 but I can't find the way to do it. Excel only allows me to put the 'x' axis into a logarithmic one, but the scale for 1/3 octave band is not this ...
0
votes
1answer
45 views
Column graph with multiple grouped values and one value above all of them as goal and with filled space between
I wish to create some kind of a special chart. I have 4 values, 3 are values measured over 3 years for state and the 4th is the goal where should it all go in future. The chart I want is a column ...
0
votes
0answers
91 views
Excel Radar chart to visualize data
I have a set of data with which I want to produce a Radar chart for easy comparison.
This is just like an inventory list with A,B and C as the products list, I want to achieve the following :
...
2
votes
0answers
72 views
Constructing an annual cycle/radial diagram in PowerPoint
I would like to make a diagram like the below in PowerPoint, but I can't figure out how to draw the curved boxes (like the ones that say "Fishing" or "Trapping" in the chart).
Diagram
...
0
votes
2answers
47 views
Excel for Mac - chart with no interpolation of discontinuities?
I would like to draw a chart in Excel for Mac with no interpolation on discontinuities, like this:
How can I do that?
1
vote
1answer
91 views
pivotslicer connected to multiple pivotcharts
Can I connect my pivotslicer to multiple pivotcharts, but on different category levels, so If for example I have a categorytree that goes:
Department
--> Section
If I choose "Section A" Then I can ...
0
votes
1answer
53 views
Excel PivotChart count rows where not blank
I've started using Excel's PivotChart to analyze data about customer requests. All my customer requests is stored in a sheet, with columns like "City", "Inspectiondate" and "Quotedate". If there was ...
0
votes
1answer
59 views
Excel 2010 charts from ungrouped data
I have a sheet that contains lots of information about jobs in a company. One of the columns is "city". That column contains values as such
Falun
Borlänge
Stockholm
Uppsala
Borlänge
Stockholm
...
0
votes
1answer
44 views
How can I increase Excel's graph axis area?
This is what the x-axis of my graph currently looks like (Excel 2010):
The dates are in the format YYYY-MM-DD, but as you can see month and date are chopped off. I tried resizing (the dots at the ...
1
vote
1answer
26 views
How to efficiently analyze simulation results with various degrees of freedoms?
I have been doing a lot of application testing, trying different libraries, threading ratios, operation distributions, etc... I want to be able to quickly generate graphs from my run data.
The data ...
0
votes
1answer
46 views
Getting more than 100 data points to only represent part of 100%
I am trying to graph stance phase of gait, which in only about 60% of the entire gait cycle (heel strike of one foot to heel strike of the same foot) But in the data out put there are 140 cells or ...
1
vote
2answers
754 views
XYZ 3D-chart in Excel
I have a table of data as follows:
X Y Z
N1 2 5 6
N2 2 7 8
N3 0 1 2
N4 0 4 5
N5 9 10 10
N6 4 9 9
N7 0 2 4
N8 0 7 8
N9 0 7 8
Now I would like to ...
0
votes
1answer
280 views
Adding 80% horizontal goal line to pivot chart
I have a curve pivot chart to which I'd like to add a goal line with a static 80% horizontal line.
I've seen some people suggest that one could merely add a column with 60% to the dataset. My dataset ...
0
votes
1answer
379 views
Is it possible to create a broken X axis in Excel 2007?
I'm trying to find a solution to a problem that I have with my data.
In my data series, I have Temp over Time plotted on a scatter graph in excel. The data plots a period of around a week in the ...
0
votes
1answer
24 views
Excel table / chart issue when updating the select data to a smaller amount
I believe I have a simple fix but cannot find the answer anywhere online.
I have a table that looks something like:
date / total1 / total2 / total3
mon / xxx / xxxx / xxxxx
tue / xxx / ...
3
votes
1answer
323 views
Sample data to create Excel timeline
I am trying to create an Excel timeline like the one shown here. I am not understanding how the sample data would look and how to go about making this. Please post a screenshot or explain how to ...
0
votes
0answers
46 views
Labels inside bar in LibreOffice Chart
I have a bar graph with dates, three categories per date and score. It looks somewhat like this:
date score
01 --------
----------------
-------------
02 ----------------
...
0
votes
0answers
99 views
How to graph events per time in excel (from log file)
I have a log file in the following format:
A | B | C | D
DD.MM.YYYY|HH:MM:SS|DEVICE|EVENT DESCRIPTION
what I want to do is, create a graph with the time on the x-axis and the events ...
0
votes
1answer
140 views
Scatter diagrams with group labels for X/Y coordinates
I'M trying to create a map layout from an Excel spreadsheet in Excel 2003.
I have x and y coordinates in columns as well as group name and place name. I tried using a scatter chart but I can only ...
1
vote
2answers
711 views
Excel or PPT: How to have two pie charts, but one legend
I would like to design a slide that shows two pie charts of the same size side-by-side, but with a single legend that is centered on the page beneath both charts. I can easily create one of the pies ...
0
votes
1answer
182 views
Excel scatter graph fill inside shape
I would like to fill the area between two graphs.
My data is in the following format:
x y
0 0
1 1
2 4
....
0 0
As you can see they start and end at the same point. For my data it draws a chart ...
1
vote
1answer
220 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 ...
1
vote
2answers
92 views
How do I disable screen updating while reformatting an Excel 2007 chart?
I have a chart with about 70,000 data points. When I format the axes or data series, Excel automatically updates the chart before I am finished editing the value. This is very slow (1+ minutes), even ...
0
votes
0answers
70 views
Place multiple columns onto one line
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
119 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
29 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
82 views
Create pie chart with single sector separated from the rest?
Is it possible to use LibreOffice (I'm currently using 3.5.4) to create a pie chart where a single sector of the chart appears removed from the rest?
If so, how to do it?
Alternatively, can someone ...
2
votes
1answer
263 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 ...
0
votes
1answer
72 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
2answers
358 views
How do I create a chart in Excel with dynamic series based on the data content?
How would I define a chart in Excel (2010) that shows a time series graph containing various series based on the data content itself? For example, here is a data set:
Date Series A Values
...
0
votes
0answers
77 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
272 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
109 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
354 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
124 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 ...
1
vote
2answers
2k 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 ...
