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

learn more… | top users | synonyms (1)

1
vote
1answer
780 views

How do I create a PivotChart from a subset of PivotTable data?

As part of a dashboard, I've created a PivotChart from a PivotTable in Excel 2010, but the PivotTable includes extra columns that are cluttering up the chart. But when I adjust the values list on the ...
1
vote
1answer
358 views

How to have Excel chart connect data points when no value?

I'm charting daily values using a line chart. On some dates, I don't have any data. I would like the chart to connect the data points for which I have data across any gap in data. So for example if ...
2
votes
1answer
3k views

How to make a Pie radar chart

I want to create a circular chart in Excel with 8 sectors like in this example: Instead of representing the percentage like in a pie chart, I want the actual value like in a radar chart. Is it ...
0
votes
1answer
125 views

How can I create an automatically updating chart from a different worksheet with blank spaces in excel 2010

I have a worksheet that lists every day so I can see if any tests were performed that day. If there were tests, then the average and standard deviation of that day show up in the next two columns. I ...
1
vote
1answer
633 views

Excel custom axis label

I'm having troubles with some charts I'm creating using Excel. Some of the values I'm plotting are too big (264) to be labeled in the axis. Due to this, Excel automatically puts them in scientific ...
6
votes
4answers
540 views

How can I make a pictograph?

How could I make a chart similar to the one below? Of course, I could use an app like Microsoft Paint, but that would be too time-consuming and awkward. What would be a simple way to do this?
0
votes
1answer
448 views

How do I create bar charts with ranges as the x-axis in Excel 2010?

I am trying to create a bar chart for say some data, say for example 1 1 2 2 3 4 5 I want to create a bar graph so each bar shows the frequency of a range. For example, the frequency of a value ...
0
votes
0answers
111 views

how can i capture a flash object thats displayed by the browser but the swf file is kind of protected, like on scribd

i want to download a stock's intraday price chart. its a flash object. dont know whether its protected in such a manner as to not allow it to be saved on to the disks of end users(like certain files ...
0
votes
0answers
50 views

The Specified Dimesion is not valid for current chart type

I am trying to open a file into which I will copy the data from the previous file but I am getting an error while opening the other file. Here is my code Dim WSC, WSD As String Dim Filter As String, ...
0
votes
2answers
487 views

Excel 2010 line chart; limiting data points to fewer than the max

In Excel 2010, how do I limit the number of data points on a line graph to the latest (or last) 4 data? I update the spreadsheet often, but only the latest data is graphed and reported.
0
votes
1answer
320 views

Offset the tickmarks of a secondary axis

I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that ...
1
vote
1answer
337 views

Chart Categories: How To Combine X-Axis Categories

The Task I'm putting together a dashboard wherein I'm building several charts. I've attempted to use a pivot chart (2D line chart) to pull data from two different pivots (with the same source data). ...
0
votes
1answer
123 views

Excel stacked column chart with unconventional data set

I'd like to create a stacked column chart based on the following set of data: Region Segment Value EMEA Premier 20 EMEA Standard 10 Americas Premier 30 Americas Standard ...
0
votes
1answer
420 views

Line chart from multiple tables in Excel 2013

I have two sheets, "Graphs" and "Data". In "Graphs" is a line chart with a single line that gets X and Y values from tables in "Data". I want the chart to be updated automatically when I add ...
0
votes
1answer
68 views

Excel: resize chart sheet

I can create a chart sheet in Microsoft Excel 2010. I wish to resize the chart so that the proportions fill my wide screen. I right-click the chart and select Format Chart Area. Then I select the Size ...
0
votes
1answer
554 views

How do I set one to many relationships in lucid chart?

I have connected two shapes with a line in lucid chart. How do I show that it is one to many? Visio allows you to do this.
0
votes
0answers
204 views

Hiding a column from a pivot table without removing it from the chart

I have a pivot table with two columns: number of users who visited a website (impressions) and number of users who registered on the site (regs). The rows are for dates. I want to visualize the ...
1
vote
2answers
3k views

Drawing a line graph in Excel with a numeric x-axis

In Microsoft Excel 2010, I'm trying to draw a line graph with three different lines. I've got the graph looking the way I want, with one exception: Excel is treating my X-axis column like text ...
0
votes
0answers
28 views

How can I add 2 charts without legends but data from two ranges in Excel 2013

How do you add 2 pie charts to the same worksheet with no legends but instead data entered from 2 different ranges? If I add 1 pie chart I cant add a 2nd pie chart with data from 2 different columns.
1
vote
1answer
240 views

Color bands in bar charts in Microsoft Excel 2010

Is it possible to obtain a bar chart like the one in this example: (that is: I need to have vertical color bands to make "visually" group the bars for each horizontal axis' point.) Any ideas?
0
votes
1answer
1k views

How to combine Excel charts on same X-axis

I want to create two stacked graphs in one chart object. One should be Stacked Column, and another Stacked Area. They represent revenue per partner per week of the year. On x-axis are weeks of the ...
0
votes
0answers
47 views

Manipulating organization chart objects in PowerPoint 2007

I am working in PowerPoint 2007. I know if I am working with free form objects, I can align them, make one object the same width/height as another object, etc. But when working with org chart ...
2
votes
1answer
45 views

X-axis changes Excel plot output

I have the following Excel file: https://dl.dropboxusercontent.com/u/33532467/GDV_Prognose_Leben.xlsx The green hatched area is not shown properly. I would expect: The horizontal axis seems to ...
2
votes
1answer
548 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
2answers
181 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 ...
1
vote
2answers
180 views

Average using Elapsed Time processing a number of docs

I process documents and want to get a formula showing the average time to process each document. Here's my data: number of docs processed (column G) start date/time (H) end date/time (I) elapsed ...
0
votes
1answer
482 views

Scatter chart series with uneven data intervals

I have two series of data I wish to plot on the same graph: Series 1 has 10 data points, Series 2 has 15 data points. I want to show both series on the same chart (presumably Scatter) with the points ...
2
votes
1answer
2k views

Filtering A Graph of Series Data In Excel

So I currently have a line graph with 48 different lines, comparing 48 different series of data. The series are generated by changing three variables: One with two possible values, one with 4 ...
-1
votes
1answer
694 views

Convert a line graph into data [duplicate]

Am looking for a tool that will import a line graph (chart) image and convert the line into numerical data, either in a spreadsheet or a database. For example, given an image like this: It might ...
0
votes
1answer
72 views

Excel coloured line chart for grouped data?

In Excel how do I create a line Chart with each simulator being its own coloured line showing Calculation time (and potentially another colour for its Total time). Axis X = Rounds Axix Y = Time ...
2
votes
0answers
71 views

Excel 2010 / Outlook 2010 - Changing the size(with precise numbers) of a chart exported from Excel to Outlook?

If I export(copy&paste) charts from Excel 2010 to Outlook 2010, I'm not presented with a "size proprieties" option when trying to resize them. Since I have multiple chart to resize for each ...
3
votes
1answer
8k views

How can I hide 0-value data labels in an Excel Chart?

I would like to hide data labels on a chart that have 0 as a value, in an efficient way. I know this can be done manually by clicking on every single label but this is tedious when dealing with big ...
1
vote
0answers
129 views

Plotting timedata in gnuplot

I have a log file (auth.log) where non-relevant lines has been removed. I wish to aggregate lines per hour/day into the plot, meaning that each line that is within the same hour or day is aggregated ...
1
vote
0answers
141 views

LO Calc: Why are data labels placement options greyed out?

When creating pie charts I like to add the values of the individual slices to the chart. LO Calc allows you to do this ('Add data labels') By default Calc places these values in the center of the ...
2
votes
1answer
4k 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
2answers
947 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 ...
0
votes
0answers
222 views

Excel VBA updating graph data

I have several charts referencing off one particular dataset. Each chart has a different number of series. Each series refer to one particular row of the dataset for a certain number of columns (ie. ...
3
votes
2answers
972 views

How to make a chart that graphs frequency of entries?

I have an Excel workbook that has nothing but dates (sorted), in the following manner: 11/14/2011 11:53 10/14/2012 11:53 11/23/2012 19:28 12/24/2012 12:27 ... 12/1/2013 11:48 I would like to create ...
0
votes
2answers
85 views

Embed Excel Charts into Powerpoint Issue

I am currently experiencing an issue with powerpoint 2010. I have created a three part chart in Excel and am trying to export it to powerpoint. However whenever I try to paste special the excel as an ...
2
votes
1answer
238 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.
0
votes
1answer
644 views

How can I graph survey results in Excel?

I would like to graph my survey results with the numerical values of the responses listed on the vertical axis and the questions listed on the horizontal axis. For example, I imagine the questions ...
1
vote
1answer
317 views

Create a excel chart only with axis

I want to create an excel chart with only the axes namely x axis and y axis with x axis values ranging from 1 to 100 and y axis values ranging from 1 to 100 Is this possible? If so how to do it? ...
0
votes
1answer
72 views

excel chart: how to change data points format in part of the curve?

Suppose I have a curve of x(t), data points are shown as blue squres. Is it possible to easily set it, so that when x(t) is less than 0, the point will be shown as red circle? I know each data point ...
1
vote
1answer
144 views

Expanding set of y axis values in chart, developed by MS-excel?

I have developed a chart from a set of values of excel file, Now what I have to do that I have to expand the y axis values from point 5 to point 8, Can anyone please suggest me that how to do that. I ...
0
votes
1answer
509 views

Scatterplot with variable X on X axis and Y on Y axis

I have a dataset with variable A (Age) and B (performance). I want to create a scatterplot with variable A on the X axis and B on the Y axis, but Excel is acting all weird with it. I have approx 120 ...
3
votes
1answer
9k views

Excel generate and format horizontal error bars

I have been trying to generate and format horizontal and vertical error bars in Excel 2010, and there is no problem with the vertical ones, but I cannot figure out how to manage horizontal error bars. ...
1
vote
1answer
966 views

Excel error bars based not on the graph data, but a separate set of error measurement data

I have several data sets, each of which includes several tests. Each test contains several temperature samples at different locations. For each data set, I have an average of the different tests for ...
0
votes
1answer
1k views

ActiveSheet.ChartObjects(“chart”) always returns Nothing?

I'm querying for a chart in the worksheet and I can see it's there but everytime I execute the following piece of code it evaluates to 'Nothing'. Why is that? Sub DeleteGraph() Dim graph As ...
1
vote
2answers
2k views

Get Excel to base tick marks on 0 instead of axis ends (with fixed maximum or minimum)

In other words, I want Excel to anchor the tick marks at 0. I am trying to get an axis that goes from -35 to 35, but with the ticks on multiples of 10: 30, 20, 10, 0, -10, -20, -30 I have set set ...
1
vote
1answer
351 views

Get Excel to use column of numbers as labels (equally-spaced on x-axis) instead of as x values (x-axis co-ordinates)

It could be an easy question but I can't find a proper way to accomplish my task. I have a simple graph and all I want is to show the X values I wrote in the first column at the bottom of the graph ...