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

learn more… | top users | synonyms (3)

2
votes
2answers
2k views

How can I hide 0% value in data labels in an Excel Bar Chart

I would like to hide data labels on a chart that have 0% as a value. I can get it working when the value is a number and not a percentage. I could delete the 0% but the data is going to change on a ...
2
votes
3answers
40k 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 ...
2
votes
1answer
109 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 ...
2
votes
2answers
247 views

Graph-like data editor tool?

Is there any unified editor program for creating, mainpulating and visualizing graphs, trees... or maybe any custom structured data. The accent is on editing, not visualization, i.e. not a drawing ...
2
votes
3answers
5k views

Is it possible to have a custom data table visible underneath a chart in MS Excel?

I have a column chart with a single series of data to be shown on the chart. However, I also have another column of data that corresponds to the one being visualized, but instead of charting it, I ...
2
votes
1answer
742 views

Animate Excel Chart

I'm preparing for an Ignite talk and need to figure out how to animate an Excel chart, which will eventually go inside a PowerPoint. I would like to animate the following into a single chart/slide. ...
2
votes
1answer
476 views

Excel Error Bars From Pivot Table

When Excel generates Standard Error error bars, it takes into account the number of data points. If a chart was generated from a pivot table, does Excel use the number of points in the pivot table, 1, ...
2
votes
1answer
517 views

Generate event distribution chart in Excel

I have a single column in Excel with lots of date/time stamps (in UTC) of certain events, like this: 2014-02-20 23:04:57.9263690 +00:00 2014-02-20 23:05:02.3117944 +00:00 2014-02-20 23:05:02.7490564 ...
2
votes
2answers
3k views

Excel Scatter Chart with category based formatting of points

I have some data which I would like to plot in the scatter chart in the following format date, category, value 01-Jan,Cat1,0.03 01-Jan,Cat2,0.13 01-Jan,Cat3,0.27 01-Jan,Cat4,0.32 ...
2
votes
1answer
77 views

Having trouble creating certain graph in Excel

I want to create a graph which given a list of dates, will produce a line graph representing the number of occurrences of list dates. For example, this would be ideal. But when I try to recreate ...
2
votes
2answers
988 views

How to create an Excel chart showing a value and its change?

I would like to create a chart that shows a value and how it has changed, like this one in Excel. The importatnt thing (which I am not able to achive) is that there are two numers associated with ...
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 ...
2
votes
1answer
540 views

Scattergraph in Excel?

I am not sure if this is the right site, though here's my question: I've been trying to make a scattergraph with Excel, but not getting the result I want. I have 2 data values for one thing. I don't ...
2
votes
2answers
619 views

How can I show a line chart in Excel (or Access) with category lines that ignore missing data?

I'm collecting data for various series (A-G), at sporadic intervals. I want a line chart, with one line for each series, that is connected even if there are intervals where no data was collected for ...
2
votes
2answers
4k views

Placing labels on data points in a stacked bar chart in Excel

Is it possible to place the labels not on the Y axis, but on the data point itself in a stacked bar chart in excel? I am trying to modify the timeline template available here so that my labels for ...
2
votes
2answers
531 views

Best software to build charts (pies, bars) [closed]

I am somewhat disappointed with Excel charts and short of building my own with a vector graphics too, is there something really awesome for charts?
2
votes
2answers
63 views

Indicating trends within sparklines in Excel

I have created a load of sparklines in Excel for a variety of diseases over time. However, in order to identify trends from these sparklines, it would be useful to include a little more information ...
2
votes
1answer
209 views

Excel: How to create a nonuniform stack chart

I want to create a stack chart that shows the timeline of 3 phases on the x-axis (intervals separated by month) and total budget on the y-axis. The budgets for all projects will stack up against each ...
2
votes
2answers
246 views

Three pairs of box whisker plots in one coordinate system

I need to plot in Excel 2007 something which looks like this: Basically I want to plot 2 box whisker plots, then have some empty space and then again 2 box whisker plots, followed by empty space ...
2
votes
1answer
8k views

A sensible way combine two stacked bar charts in Excel?

I have one chart that has several stacked bars with identical components - one for each category. Each of the components of those bars can also be represented with a stacked bar chart, like the ...
2
votes
1answer
379 views

Highlight specific points on a surface chart in excel

I was wondering if its possible to highlight a series of x,y,z points on a surface chart in excel, similar to what ive done manually in the picture.
2
votes
1answer
672 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
4k views

How do I create a line graph which ignores zero values?

I want to create a graph showing trends over time, calculated from a formula of various data. However, some data is missing, resulting in zeroes in the calculated data which the chart uses. When ...
2
votes
2answers
6k views

Excel: Bubble chart labels - use 4th dimension?

I've got a dataset that has 4 dimensions - lets say they're the following: +------------------------------+ | Type | Amnt |Price| Quality | +-------|------|-----|---------+ |  A    |  15  | 4.0 |   ...
2
votes
2answers
3k views

Calculate the Y Axis interval for a chart

When creating a chart of, e.g. daily sales figures for the month. Does anyone know how to calculate a suitable Y Axis interval? I've been looking at Excel which seems to choose nice intervals like ...
2
votes
2answers
1k views

Excel: ROUND() to the next unit of 5?

I'm creating a lot of graphs, so I'm making a common scale to be able to compare them using MAX/MIN values that I'm hiding in the graph as a separate series. My Vertical AXIS (Y) is in units of 5. ...
2
votes
1answer
2k views

Excel graphs: How do I apply a graph template format?

I've created a format that I like. I now need to apply this format to over 900 graphs! I've seen we can save a format as a template for future use, however, I can't find the place where I have the ...
2
votes
1answer
658 views

Plotting the volume of an audio file

Most applications that play sound display its volume graphically. I need that information (the sound volume as it changes over time) written to a text file so I can plot it myself and use it for ...
2
votes
1answer
1k views

How to make Excel chart axis start NOT at major unit?

Is it possible to have an Excel chart where the axis does NOT start at the major unit? See the example below, where I want the x-axis to start at the year 2007, but have major unit 5 years and show ...
2
votes
1answer
65 views

How to attach a note to a specific date in a dynamic graph in Excel?

I have a graph that I update every month with new data. I want to annotate some comments to relevant days inside the graph, and when I update it, they stay fixed to that days. Now, I draw this notes ...
2
votes
1answer
424 views

Create graph for requests per minute and uri

I have a table that looks like this. time|uri 08:50:28|foo 08:51:42|bar 08:52:48|foo 08:53:49|bar 08:53:50|baz 08:54:02|bar 08:54:03|baz 08:55:27|foo 08:55:34|baz 08:56:47|bar I would like to make ...
2
votes
1answer
17k views

Plot scatter graph in Excel graph with 3 variables in 2D

3 Columns of Data: Date (from 1st till 31st) Variable 1 variable 2 I want to make a simple graph where Variable 1 range is X axis and Variable 2 range is Y axis, I plot the date on the graph ...
2
votes
1answer
1k views

Make two or more graphs have the same scale

I have several area graphs in an Excel spreadsheet. I want all of those graphs to have exactly the same scale. Each of the graphs have a measurement in meters on each of the axes. I want each of the ...
2
votes
1answer
1k views

Add custom forecasting line in Excel Charts

I got the following graph (in purple): I want to add the dotted forecasting line. It's a cell value, but not referenced to the point on the X-Axis (Oktober 13). I'm a bit lost as to how I could ...
2
votes
1answer
8k 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 ...
2
votes
1answer
189 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
518 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 ...
2
votes
1answer
339 views

Graph with uneven spacing in excel

I need to make a graph of follow-up data at 0, 6, 12, and 24 months. Excel for Mac 2008 puts the 24 months at the 18 month position. How do I get the correct spacing without including 18 months?
2
votes
2answers
298 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
1answer
307 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 ...
2
votes
3answers
4k 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 ...
2
votes
2answers
5k views

Excel graph - two lines, one axis with date

I want to make Excel chart that shows my accounts' balances in time. I have 2 bank accounts and I have all transactions saved in Excel. The data's format is: Column A Column B Column C Column ...
2
votes
2answers
27k views

Easily Plotting Multiple Data Series in Excel

I really need help figuring out how to speed up graphing multiple series on a graph. I have seperate devices that give monthly readings for several variables like pressure, temperature, and salinity. ...
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 ...
2
votes
2answers
403 views

Excel auto Gantt chart

I have a spreadsheet with 4 columns. Teachers, Class Taught, Class Start (date), Class End (date). I need to plot this in excel somehow to show what days of the month are booked by each teacher. I1 ...
2
votes
1answer
2k views

Zero values in Excel logarithmic chart: Can the warning be suppressed?

I'm plotting data in an Excel 2003 chart with a logarithmic scale on the Y axis. Some data points are occasionally missing, and this is represented by blank cells. The resulting graph looks like the ...
2
votes
1answer
1k views

How to create a XY (scatter) chart with three columns of data?

I have the following data: Date Name Value 1/1/2011 FOO 10 1/1/2011 BAR 12 2/1/2011 FOO 16 3/1/2011 BAR 21 5/1/2011 FOO ...
2
votes
4answers
14k views

How can I create proportionally-sized pie charts side-by-side in Excel 2007?

I have a pivot table with two sets of data as follows: 2011 2012 Slice A 45 20 Slice B 33 28 Slice C 22 2 I am trying to present two pie charts ...
2
votes
1answer
417 views

Excel distorting markers in scatter plot

I've run into an issue with scatter plots in Excel. For whatever reason, Excel is distorting the appearance of markers on the plot, such that markers within the same series do not look the same. For ...
2
votes
1answer
167 views

Make dates appear on the X-axis and the color category appear on the Y-axis

There is probably a fairly straight forward answer out there but I can not seem to find a solution online. I have a table marked up like this (column names are in bold) audit date | blindness ...