Super User
Super User

Questions tagged [charts]

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

A chart is a graphical representation of data and the relationships within that data. Among other purposes, charts can be used to compare two or more types of data or visually show the data against metrics given on an axis. There are many kinds of charts, including bar charts, pie charts, line charts, scatterplots, and Gantt charts.

1607 questions
85
votes
24 answers

How to make cells perfect squares in Excel?

In Microsoft Excel, I want to make the height of first three rows and first four columns (12 cells in the top left corner) such that these cells are squares. How can this be done? Surprisingly, Excel says: Row height: 15 Column width: 8.43 So,…
Lazer
  • 18,407
53
votes
2 answers

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 them relative to each other? Say that there are 100…
Mestika
  • 991
  • 3
  • 11
  • 16
51
votes
3 answers

Excel: How to create (truly) blank cells from formula so that they wont show up in a chart?

I have a table where track data on a daily base, compare it to a daily target I have set, calculate the gap between the two and display the data on a line chart. The data has 4 columns: A. Date (from today until 31-12-2014 C. Actual value (only…
uncovery
  • 1,928
41
votes
9 answers

Map one column to x axis second to y axis in excel chart

I'm struggling while trying to plot simple data into a simple chart in Excel (2010 beta). My data is a very simple one: Value Year ----- ---- 1 1900 5 1902 3 1912 etc. In the chart, I want year to be the X axis and the…
user939
33
votes
3 answers

Excel scatter plot with multiple series from 1 table

Say I have a table as follows: Label | X | Y | A | 1 | 1 | B | 2 | 2 | B | 3 | 2 | A | 4 | 3 | C | 5 | 4 | A | 4 | 3 | C | 2 | 1 | How can I make this into an Excel scatter plot with 3…
dtech
  • 818
29
votes
3 answers

Excel pie chart: How to combine smaller values in a single "Other" slice?

I have this pie chart in Excel 2010 (based on a pivot table): I'd like to combine all the values smaller than X% in a single "Other" slice. In previous versions of Excel, it was possible to use the "split series" option to do this. That option…
Herb Caudill
  • 942
27
votes
6 answers

How can I save a graph to a PNG or GIF file in Microsoft Excel?

How can I save a graph to a PNG or GIF file in Microsoft Excel? I know I can save as an HTML file and use the image created there, but I suspect there is a way that doesn't create other clutter of files I don't want. I'm happy to install an add-in…
fmark
  • 1,933
  • 4
  • 18
  • 18
24
votes
2 answers

Excel chart with two X-axes (horizontal), possible?

Is it possible to create an Excel chart which has two X-axes (i.e. horizontal axes, not vertical Y-axes!) ? I want to use the second axis to plot the normalized value of the default horizontal axis. I am using Excel 2007.
Rabarberski
  • 8,800
21
votes
1 answer

Stop Excel chart from changing series formatting

I have an Excel bar chart that is formatted exactly the way I like it. The bar colors, the label fonts, the grid lines, etc, etc. Here is an example: Notice the awesome formatting of the second series. Now, I want to update the chart so that its…
ElRudi
  • 464
20
votes
7 answers

What is the easiest way of visualizing data from stdout as a graph?

I have an application that prints data to stdout, a floating point number roughly every second. I would like to visualize the numbers as a graph. What is the easiest way to do this? I'm preferably looking for something I can do in the command line,…
Mads Skjern
  • 1,559
  • 8
  • 26
  • 40
19
votes
4 answers

How can I make a cell's font transparent?

I'm creating a heatmap using Excel's conditional formatting. I don't want the cell's values to show against the color background. Is there a way to make the font's formatting transparent, similar to what is found in the cell's fill…
dav
  • 10,618
19
votes
1 answer

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?
Justinas Dūdėnas
  • 628
17
votes
4 answers

How to fill in missing dates in chart

I'm looking for a simple way to chart a list of values each correlating to a date. For example: Date Value 11/7/13 2 11/8/13 2 11/11/13 3 11/14/13 2 Etc. The problem is, the chart does not show a proper trend since many dates have no…
user176692
  • 273
17
votes
6 answers

How do I overlay two histograms in Excel?

The first few lines of my raw data looks like this: 0 -4.05291 0 -2.75743 0 -0.374328 1 -23.829 1 -21.5973 1 -21.0714 I want to plot the data points with 0's and 1's separately as a histogram. This wasn't that hard to do: insert…
Allure
  • 303
16
votes
1 answer

Excel 2010: Can I hide columns without excluding the data from a graph?

In Excel 2010, is it possible to hide columns but still have the values show up in a graph? I have a graph of monthly data going back to 2005, with each month's data in a column. If I hide the columns, say, for everything before 2010, then the graph…
chris
  • 9,595
1
2 3
…
99 100