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

**1**

vote

**2**answers

362 views

### Desktop software for data analysis, like Business Objects “Lite”

My data set is sourced from ~100k users, with a few million records scattered over a dozen tables. Just too big for Excel, but not quite a data warehouse. It's sourced from a web-sites user base and ...

**-1**

votes

**1**answer

24 views

### Creating auto-shapes in excel based on cell values

I'm trying to create (and maybe I shouldn't be using excel at all) a calendar with gantt chart style display in excel. I know there is software that is designed for gantt charts by themselves. That's ...

**1**

vote

**1**answer

21 views

### Pie Chart in Excel, is it possible to have a slice for a remaining balance?

There is a budget for each employee to use on expenses. We keep track of expenses throughout the year as it gets used. At the end of the year, a lot of these budgeted dollars do not get spent and i'd ...

**0**

votes

**1**answer

32 views

### Excel: How to Group Dates Per Week in Line Graph

I have data that looks like this:
Actual End Date ----CP
2016-04-22------------4
2016-04-26------------3
2016-04-26------------9
2016-04-22------------7
...

**0**

votes

**0**answers

14 views

### Conditional formatting of “difference lines” in a 2 series chart

I have 4 columns of data:
1st column is the name of the Route
2nd column is Time1 in decimal hours
3rd column is Time2 in decimal hours
4th column is TimeDifference in decimal hours (or decimal ...

**1**

vote

**4**answers

56k views

### Scatter chart, with one text (non-numerical) axis

Lets imagine I manage 100 pizza stores. I want to plot a chart each day, of how long deliveries are taking.
My data might look like this:
London 23
London 22
London 44
London 18
...

**0**

votes

**0**answers

15 views

### Excell Gantt Charts or usage of room resources by blocks of time

I am trying to create a chart that shows how frequently conference rooms are booked within a month in time intervals. I have tried a Gantt chart but the times on the axis are showing 12:00AM only. ...

**0**

votes

**1**answer

16 views

### create stacked graph with subcategories

I'm trying to create a stacked bar graph in excel with more than just simple series.
What I have:
company name, product name, product market share per year (2013,2014,2015).
On the vertical side ...

**0**

votes

**1**answer

32 views

### Excel Dynamic Chart- Range Name based on IF formula not accepted as 'Series Name'

I have created a simple Dynamic Line Chart in Excel 2013 as seen below. As I change the Year in Cell D1, the Series on Y Axis changes accordingly. The X Axis series is static. When I use Excel Range ...

**0**

votes

**1**answer

37 views

### Make an excel chart based on a pivot table, with multiple years

I've had this problem for some time. Using Mac, Excel v15, 2016.
As you can see, I have 2015 and 2016 (ignore the months showing as Jan-15, think of them as just month names; I tried editing that ...

**1**

vote

**0**answers

9 views

### Plot a chart directly from a function in Microsoft Excel

I need an help with chart plotting in Excel (I'm using Excel 2016) let's say we have a simple function like:
y=1/x
Right now, to plot a chart based on this function I use two columns. In the left ...

**0**

votes

**1**answer

12 views

### Excel Pivot Reports & Graphs - Issues with tracking data

I exported my data from a sharepoint list into a pivot table in excel and have some issues getting my desired statistics from my table.
Currently my table consisting of a team name, and then their ...

**-1**

votes

**0**answers

19 views

### How do I make this kind of line graph with MS excel or if not possible what is the next possible solution?

1I wanted to make this graph. The first figure is a single figure line graph with 4 vertically connected line graph . x axis is weeks and y axis is %. The other figure is an 8 line graphs connected ...

**0**

votes

**0**answers

16 views

### Creating a year wise excel chart with twin axis?

Is it possible to make a chart with main axis of amount and secondary axis of number year wise? The data sheet has for each row, two columns of data ( Units sold & amount) under each column year.
...

**0**

votes

**1**answer

28 views

### How to configure IF function to dynamically display three data tables

I downloaded the Microsoft Office Excel Template called "Vehicle Log Book" and I'm having trouble adjusting the graph so it includes 3 items in the drop down list, instead of 2.
I believe the issue ...

**1**

vote

**1**answer

19 views

### Excel Not Formatting Axis Labels Properly

I have a Pivot Chart (Excel 2016) that displays the instances of a range of dates.
It is displaying the X Axis label as "21-Mar", "22-Mar", etc.
I would like it to display as "Wednesday, March ...

**0**

votes

**1**answer

11 views

### Chart Displaying Odd Axis Labels

I have created a chart that counts and display occurrences of a range of dates. The axis labels for each column display the date like this:
"Thursday March 17, 2016, Friday March 18, 2016"
The next ...

**0**

votes

**1**answer

10 views

### Skip Zero Value Rows on Bar Chart

I have a table of values that is similar to this:
Fruit Qty
Apples 5
Oranges 2
Bananas 0
Peaches 1
When I create a bar chart I only want those rows with positive values to be displayed, ...

**1**

vote

**5**answers

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

30 views

### Prevent chart with Smooth Lines from exceeding a minimum value

How do I prevent smooth curve in Excel from going below 0 on a graph? I need a smooth curve because I don't have enough data points, it looks terrible as a straight line. As you can see on this graph ...

**0**

votes

**2**answers

12 views

### Chart Range Changes When New Column Pasted in

I have an excel sheet with a chart on it. The data range for this chart is
='Sheet A'!$A$1:$N$4,'Sheet A'!$A$7:$N$10
This works fine, however every month I add new data to the sheet. I do this by ...

**0**

votes

**1**answer

31 views

### Excel Chart, Formatting Line with Stack Column Chart

I have a stacked column graph, it is duration based, goes for 16 hours, (starting at 4:00 pm on T, and ending at 8 am on T+1)
I have the primary axis completed, showing 0 to 20 hours, how can I get ...

**0**

votes

**1**answer

31 views

### Excel macro: replace entire worksheet with different values [closed]

Is it possible to replace entire worksheet with different values at the click of a button through macro? There are no "replace X with Y" or any recognizable pattern, I'm trying to replace ALL values ...

**1**

vote

**1**answer

25 views

### How to plot a complex table relation on excel?

How can I generate a table as displayed in the image attached using Microsoft excel. The x and y axis in yellow are simply perfect squares while The table content is composed of axis sums. I cannot ...

**0**

votes

**1**answer

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

**0**answers

23 views

### How can I plot cwnd vs. time and queue occupancy vs. time graph of the buffer from wget output?

I had used a smaller buffer for 2 host network h1 and h2 using sudo ./run-minq.sh command. Now at first, I observed the wget from h1 to h2. Next I start iperf and wget simultaneously and observed the ...

**0**

votes

**0**answers

17 views

### In Excel, how can I format a time-based X axis in a PivotChart when my time values are irregular

I have a PivotChart to visualize some time-series data collected in irregular intervals. It's about 30 seconds but not exactly, so some minutes have 1 or 3 data points. I've also made "helper" columns ...

**3**

votes

**3**answers

1k views

### Chart data by month

I've the following data in an excel spreadsheet:
Date (dd/mm/yyyy) Value
----------------- ---------
01/04/2011 123.45
03/04/2011 7234.25
16/05/2011 80.00
...

**7**

votes

**9**answers

88k views

### How to change x-axis min/max of Column chart in Excel?

Here i have a column chart of binomial distribution, showing how many times you can expect to roll a six in 235 dice rolls:
Note: You could also call it a binomial mass distribution for p=1/6, ...

**1**

vote

**3**answers

14k views

### Excel bar chart - how to make axis as time scale

My data has column 1 = date (date format), column 2 = quantity (number format). The data looks like:
date qty
1/3/2010 5
2/3/2010 2
2/4/2010 3
2/9/2010 1
4/13/2010 5
5/31/2010 5
...

**1**

vote

**0**answers

20 views

### Logarithmic scale in Excel chart with non-transformed axis labels

I'd like to change a plot so that the y-axis has a logarithmic scale. But when you check the box "logarithmic scale" it also transforms the axis labels.
I would like to have the axis show only ...

**-1**

votes

**0**answers

44 views

### How to find the y-values corresponding to new x-values from a graph

I have this data, which corresponds to x-values from 0->29.53 (in days) in intervals of 0.01 as shown on the excel spreadsheet attached, on the 1st Sheet. I have the graph plotted in the spreadsheet ...

**0**

votes

**0**answers

21 views

### x axis formatting with dynamic excel chart

I'm having a problem with a dynamic x,y chart.
I set up named ranges using this method:
My x axis label is "time" =OFFSET(graf!$D$2,0,0,COUNTA(graf!$D$2:$D$1000)-1)
I do the same for my data (y ...

**0**

votes

**2**answers

19 views

### How do I highlight some specific parts of a chart depending on the axis line?

I would like to know if it is possible to highlight (underline) some parts of a chart other than manually ?
See image below for a pivot chart where I underlined manually all the parts that interest ...

**4**

votes

**2**answers

30 views

### Finding multiple local maxima and placing data labels on corresponding chart

Spectrum that I am using complete with 10,000 data points
I am a chemistry student of sorts and I frequently have instances where I need to find multiple peak heights (as seen in the attached ...

**3**

votes

**5**answers

19k views

### Changing data series line weights in Excel chart (many at once)

Is there a way to edit the weight of all lines at once on an Excel line chart?
I have a graph with about 50 data series on it, and it's too much to go through all of them and change the weights ...

**-1**

votes

**1**answer

30 views

### Format Data in a Chart Data Table

I'm working on a project where I'm creating charts programmatically using VBA. These charts include data tables. The business requirements specify that the chart data cannot be tied to the source ...

**3**

votes

**1**answer

888 views

### Free or Open Solution for Storing and Charting CSV data [closed]

I'm presently storing CSV files, combining them, opening them in open office, creating pivot tables and then generating charts from the spreadsheet.
I've looked at OOBase, but appending csv files to ...

**0**

votes

**0**answers

9 views

### How to reverse the X axis of time series data [duplicate]

In Excel 2003, I have a time series from a financial report that goes something like this:
2007 2006 2005
Amount 300 200 100
I want to create a graph of the time series that looks ...

**3**

votes

**1**answer

22 views

### Plot an Excel Chart where the date is on the x-axis and the different times as the Two Series

I have data like this in a table:
Date Time Min RTT
3/28/16 10:00 AM 42.91
3/28/16 10:00 PM 41.81
3/29/16 10:00 AM 70.61
3/29/16 10:00 PM 42.81
I would like to plot it where ...

**0**

votes

**1**answer

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

**2**

votes

**1**answer

5k views

### Create progress bar or milestone type graphs in Excel 2007

I want to display project progress in Excel 2007. Is there a way to show a progress bar like graph filled for completed percentage and empty until end date for a milestone or the whole project? It ...

**0**

votes

**3**answers

32 views

### Can anyone tell me the name or type of simple chart this is.

I am looking to create a table of content of sorts for my application like I have seen other doing but I have no idea what this called or what generates it. If anyone can help me figure this out I ...

**0**

votes

**0**answers

20 views

### Create a month specific graph from a list of dates and different categories

In my job we receive observation cards which, among other things, have dates and categories. I am trying to create a graph, ideally a bar chart, and separately a pie chart which will show a particular ...

**0**

votes

**1**answer

26 views

### Swap X and Y axis table - bar char

I want to create a chart that has on X axis the complexity and in the Y axis the time with Microsoft Word 2013. Then, in the same chart I have to put the time and the complexity of two different ...

**1**

vote

**0**answers

32 views

### Excel Chart, Axis Formatting

I have a problem with my Y Axis.
Here is a sample (click on it for a larger view):
As you can see the axis #'s are off. The chart numbers are actual finish times for stages in a race, these times ...

**0**

votes

**1**answer

72 views

### Plotting difference between logged sent-time / acknowledgment-time in Excel 2011

I have an excel sheet which is a log containing the time that a message has been sent and the time that the corresponding acknowledgment for that message was received. It also contains the time ...

**0**

votes

**1**answer

110 views

### Displaying data in Excel graph only up to current date?

I have an Excel chart that displays 5 sets of data in a single scatter plot, where the X axis is the date of occurrence. In my table, I have both actual values from previous dates and projected values ...

**0**

votes

**2**answers

2k views

### Day of the week and Time Graphing in Microsoft Excel

I have an Microsoft Excel document with two columns, date (mm/dd/yyyy) and time HH:MM(a/p). Each row represents an order (The day it was placed and the time it was placed).
How can I graph this so ...

**0**

votes

**1**answer

50 views

### Formatting time s:mm.00 in Excel (Office 2010) and graphing

My son is a competitive swimmer. I would like to make a stacked bar chart using the various time standards for each stroke. The times are listed in m:ss.00 format. I have several problems I need help ...