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

**0**

votes

**1**answer

58 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

**1**answer

343 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 ...

**3**

votes

**1**answer

256 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

**1**answer

118 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

**0**answers

250 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

**1**answer

281 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

**2**answers

101 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

**1**answer

287 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

**1**answer

162 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

**1**answer

99 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

**1**answer

374 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

**1**answer

30 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

**1**answer

137 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 ...

**2**

votes

**2**answers

12k 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

**1**answer

2k 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

**2**answers

3k 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

**1**answer

67 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

**1**answer

572 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

**1**answer

193 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 ...

**2**

votes

**3**answers

9k 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

**1**answer

797 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

**1**answer

1k 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

**2**answers

249 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

**0**answers

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

**1**answer

242 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

**1**answer

36 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

**1**answer

141 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

**1**answer

348 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

**1**answer

179 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

**2**answers

1k 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
...

**9**

votes

**1**answer

208 views

### How to turn a 3D chart into something watchable on a 3D television?

Let's say I have a 3D scatter plot in R or a data frame with 3 fields filled with numeric data.
How can that be "turned" into "something" watchable on a 3D television (like a random big screen TV ...

**0**

votes

**0**answers

118 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

**3**answers

710 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

**1**answer

149 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

**0**answers

512 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

**1**answer

189 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

**2**answers

5k 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

**1**answer

312 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

**1**answer

597 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

**2**answers

709 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

**1**answer

102 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

**3**answers

2k 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

**1**answer

112 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

**1**answer

277 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

**1**answer

176 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

**1**answer

9k 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

**2**answers

2k 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

**1**answer

145 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

**1**answer

129 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

**0**answers

74 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 ...