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

learn more… | top users | synonyms (3)

1
vote
0answers
9 views

Excel Pivot chart with a legend summary table having SUM and COUNT of values

I have a pivot chart display some data I'm interested in. Using a summary table below the chart I can plot the SUM of the values. This works great for me since the data rows contains a 1 if I want to ...
0
votes
0answers
24 views

Find the number of points between two “scatter with smooth lines” series in excel

I've attached an image that shows the scatter plot I've built in excel. I need to know how many points are between the dashed line series and the solid line series just to the inside of the dashed ...
0
votes
0answers
18 views

How do I plot two different data sets that have different x-axis?

My question is probably better explained with example data, so here's what I'm trying to plot and compare on the same graph/chart: First Data Set: Percentage A | Price A | Price B 5% | $0.25 | $0.37 ...
-3
votes
0answers
20 views

Need a chart type to display turn around time for code requests received during the month [closed]

I need to display on the dashboard the following details every month need some idea on how to plot the data and use the best fit chart for this data Data to report - Number of EAP and EDG requests ...
0
votes
0answers
29 views

Add total to pivot chart

I have a set of data of all the stops in the plant here. The data is arranged in columns as followed: Column A Fabrication number Column B Start Date Column C End date Column N observation (this is ...
0
votes
1answer
13 views

How to plot a line chart with multiple “Y” axis variables of different units?

I have a dataset with multiple variables all correlated to time. I am interested in plotting these variables on Y axis and time on the X axis. I have seen so many posts that talk about using ...
2
votes
1answer
12 views

How do I resize chart elements?

I created a pie chart in Excel 2007 and then copied and pasted it into a 2007 PowerPoint presentation. I'd like to resize the boxes on the pie charts without resizing the entire chart, but whether I ...
0
votes
1answer
44 views

How to flip X and Y axes in Excel scatter chart with more than one series [duplicate]

I don't understand how to perform a simple 90 degree axis manipulation in Excel. Here is my data: ╔════╦══════╦═══════╗ ║ Y ║ X1 ║ X2 ║ ╠════╬══════╬═══════╣ ║ 1 ║ 0.00 ║ -1.00 ║ ║ 2 ║ 0.50 ...
-2
votes
1answer
35 views

How to represent/structure Excel table data to get Quarterly Chart?

I need to create chart similar to this one. anybody here to tell me, in order to get this kind of graph output, how Excel table data can be represented/structured? Thanks
0
votes
1answer
28 views

Graphing data points within a day

I have a spreadsheet that is a series of pings throughout a day and I need to visually represent that. I think a scatter plot is probably the best way, but I'm open to ideas and suggestions. When I ...
0
votes
0answers
19 views

Bounded logarithmic graph in excel

I have a function for which i want to draw a graph. The x values are: 99, 99.9, 99.95, 99.99, 99.9925, 99.995, 99.9975, 99.999 - so between 99 and 99.9 there are 2 values and then under 99.99 ...
0
votes
0answers
18 views

Excel 2013 XY Scatter and the label issues - something more complicated / VBA

I have a scientific machine passing values from different sensors in an Excel Worksheet including a time stamp. To have all values compared at once, I created a chart having multiple y-axes, so each ...
0
votes
2answers
62 views

Chart with categories and sub-categories in x-axis

Is it possible to have an x-axis with subgroups? For example, I need to graph Categories: Greeting (1.1, 1.2, 1.3), Call Reason (2.1, 2.2, 2.3, 2.4), Conclusion (3.1, 3.2, 3.3) , Accuracy (4.1, 4.2, ...
0
votes
0answers
20 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
votes
1answer
36 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
1answer
26 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
1answer
69 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 2016-04-26------------6 ...
0
votes
0answers
17 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
1answer
44 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 ...
1
vote
1answer
22 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 ...
1
vote
0answers
11 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
1answer
41 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 ...
0
votes
1answer
14 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 ...
0
votes
0answers
19 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
1answer
32 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
1answer
36 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
1answer
12 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
1answer
13 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, ...
0
votes
1answer
53 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
2answers
13 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
1answer
34 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
1answer
30 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
0answers
25 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
0answers
26 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 ...
0
votes
1answer
47 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 ...
1
vote
0answers
23 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 ...
0
votes
0answers
37 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 ...
4
votes
2answers
38 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 ...
0
votes
2answers
25 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 ...
0
votes
0answers
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 ...
-1
votes
1answer
43 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
1answer
28 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
3answers
33 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
0answers
23 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
1answer
28 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
1answer
58 views

Dynamically choose a chart measure in Power BI

I have a number of charts within a single dashboard in Power BI, as well as a number of measures that I want to examine individually within this dashboard - hopefully by cycling through them. ...
1
vote
0answers
36 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
0answers
15 views

Predefined chart styles in Excel available to other users?

I need to set up a MS Excel document with custom chart styles. As far as I understand the style of an existing, customised chart can be saved as a predefined chart style. I then need this style to be ...
0
votes
1answer
44 views

How to Create a Column Chart in Excel with Primary and Secondary Axis Without Bars that Stack over Each Other

Here is the data that I want to display in a column chart: The desired outcome is a column chart with 2 Y axis. Set1 and Set2 should be plotted on the Secondary Axis, whilst Set3, Set4 and Set5 ...
0
votes
0answers
42 views

I am trying to plot 2 data sets with different X-axis values in Excel

I have two sets of data in excel that I would like to plot in Excel. Both X-axis go 0-600, but A goes up by 10 and B goes up by 5. Each X-value has a Y-value, so for B I have twice as many data ...