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

learn more… | top users | synonyms (3)

2
votes
0answers
85 views

How to interpolate a graph with multiple series in Excel?

I have a X-Y scatter plot in Excel 2007 with multiple lines on same plot like a series for 2%, and other series for 3% and 5%. How can I interpolate such data? For example, if I want to know a value ...
2
votes
0answers
41 views

How to set a non-linear Y axis on a graph in Word?

I need draw the chart similar type with the chart below but I don't know how to set up the Y axis value and resize to view as this.
2
votes
0answers
49 views

Legend-placement in two different charts is different with same settings

I have two charts, and in both of them I want I want to place the legend in the upper right corner of the chart-area like so: However when attempting to add a legend to the second chart, it is ...
2
votes
0answers
2k views

Add custom error bars to multiple series in one graph

I have my data in a csv file like below, except with more columns and rows Mean values 61 43 Sample 1 0.009 0.059 Sample 2 0.108 0.099 Sample 3 0.043 0.038 ...
2
votes
0answers
157 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 report,...
2
votes
0answers
100 views

Extract data from graph with curve as axis

I need to get data from a pretty simple yet not really common type of plot (graph). If you take a look at this image, you will notice that the Y axis is irrelevant and that curve has to take its place....
2
votes
0answers
309 views

MS Project 10 & 13 - Creating Custom Gantt Chart for Resource Allocation

I have created a very basic setup to better monitor staffing and scheduling decisions for my firm. Essentially, I create one task for each new project and assign the resources that will work on that ...
1
vote
0answers
17 views

Is there any way to put a thermometer chart inside of the category name on another chart?

I'm using Excel 2016 and have a bar chart showing Manhours/Actual Hour. I want to make the horizontal category labels have a separate bar chart within them, showing time spent out of time possible (...
1
vote
0answers
10 views

Date axis with Pivot Chart (Excel 2016)

I have a list of dates across the X-axis of the form mm/dd/yyyy and have the pivot field formatted as a date. When I attempt to format the axis to be a date axis, Excel does nothing. I can literally ...
1
vote
0answers
10 views

Charts / text boxes in Word not appearing properly when saving as PDF

I have a Word document (Office 2007) that I'd like to save as a PDF. Most of the document saves perfectly, but some pie charts and text boxes are not appearing correctly in the PDF. They don't appear ...
1
vote
0answers
40 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 ...
1
vote
0answers
14 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 ...
1
vote
0answers
30 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
vote
0answers
42 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 ...
1
vote
0answers
43 views

Office 2013: Pasting graph from Excel changes decimal separator. Changing the format code turns my axis values into zeroes

I have created charts in Excel 2013 where I have managed to change the decimal separators to points instead of commas (I'm on a Swedish computer). When pasting these charts to Powerpoint (or Word for ...
1
vote
0answers
37 views

arranging legend labels in minitab

I want to arrange my labels shown in legend box in Minitab 17 in a way that I have my legend labels in rows instead of coloumns since I want to put my legend under my graph not beside it. I have shown ...
1
vote
0answers
175 views

Programmatically rotate a pie chart to fix the labels

Part 1 I'm looking at a way to automatically rotate (with VBA) a pie chart depending on the data. The data is changed dynamically depending on the month selected. Here is an example of the kind of ...
1
vote
0answers
87 views

how to generate a graph with asciidoc?

I was checking out this asciidoc tutorial and really liked the graph at a,b,c,d so i create such a file with that ascii text 1.ad went ahead and installed asciidoctor chrome extension but it just ...
1
vote
0answers
79 views

Excel chart shows horizontal axis as the same value after pivot refresh

I have created a simple clustered column chart to display request volumes (y-axis) over time (x-axis, months). All of that is linked to a little CountIf table that sources data from a PivotTable (as ...
1
vote
0answers
429 views

How to create a 100% stacked column chart if I have total

I'm trying to create a 100% stacked column chart using Excel 2013 Pivot Table to show what % of Column A is of a Total Column B. However the 100% stack column chart doesn't seem to work if I have a ...
1
vote
0answers
741 views

Excel Charting - How to edit the X axes for positive value on both sides?

I have a stacked chart, with the X axes at bottom. So there are two bars protruding along the y axes from each category. to get an idea of the X axes, it's something like this How to plot positive ...
1
vote
0answers
191 views

How to extract contour lines from a surface plot in Excel

I have several surface plots. I would like to combine one contour line from each plot into a single plot. Is there a way to extract the contour line that excel generates?
1
vote
0answers
263 views

Filtering values on Excel Pivot Chart

I'm importing data into Excel Pivot Chart from SQL Server. I'm trying to filter out Values (decimal type on SQL) below a certain threshold. For this, I click PivotChart filter and see that filter may ...
1
vote
0answers
142 views

Create a pie chart from amount/category pairs

From a table like Amount | Category 2 A 1 B 5 A how to create a pie chart with one sector per category found in the second colum and the summed up values for each ...
1
vote
0answers
89 views

Format Excel to Display Second Time Zone in Graph

I need to make my Y axis in a graph show the time in HH:MM (local) format as well as HH:MM +/- offset for another timezone. Form example: 09:00 EST 06:00 PST Is there some sort of custom format ...
1
vote
0answers
65 views

Excel: Replace Number Format in Diagram

I have an Excel Workbook which will be sent to a client and I need to get the thousands and decimal seperators right. I have a Workbook.Open routine which will change to custom formatting (and back on ...
1
vote
0answers
288 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 '...
1
vote
0answers
764 views

Excel chart axis values are doubling up along the axis

Excel chart axis values are doubling up along the axis - how do I stop this happening? It is in both the primary and secondary scales. eg the axis shows 18, 20, 20, 22, 22, 24, 24, 25
1
vote
0answers
504 views

How can I change the default font size that is set on charts in a PowerPoint template?

As the title says I'm interested in knowing how I can change the default font size that is set on charts in a specific PowerPoint template. I'm not interested in using chart-templates for this, since ...
1
vote
0answers
74 views

Finding more flexible 'chart-to-code' software

I'm looking for suggestions of a new software development tool for any object-oriented development language e.g. C++ , C# , VB etc. Here's some examples of some software coding: I'm looking for ...
1
vote
0answers
395 views

How to plot this in iwork-numbers

I have an array of data like this 0,1 0,56 0,4 0,57 0,6 0,006 0,34 0,46 ... I have another array of data that classifies the data above in categories like this: from 0,1 to 0,5 category A from 0,...
0
votes
0answers
14 views

Switch Excel chart from stacked by category to sum

I have 2 charts that shows invoice figures by month. The figures are broken down into categories. Is there any way to have an option to use the same chart to show them stacked by category OR the sum ...
0
votes
0answers
21 views

xmgrace fails to load after installation

I installed xmgrace via Homebrew on my machine (Macbook pro running os x 10.11.5) but when I execute xmgrace on the command line I see the following error: Warning: Widget must be a VendorShell. ...
0
votes
0answers
8 views

Disable pie chart shape protection in Visio 2013

I have a pie chart I have rotated so the slices are symmetrical. I want to rotate the text in the right image to horizontal. I've tried The Master Explorer The Shape Design Protection button ...
0
votes
0answers
20 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 ...
0
votes
0answers
43 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
0answers
20 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
30 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
0answers
25 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 ...
0
votes
0answers
24 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
0answers
24 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
0answers
38 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
53 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
0answers
50 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
0answers
26 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
0answers
18 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
0answers
54 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 points....
0
votes
0answers
25 views

Two data area in one diagram

How can I do this in one diagram in Excel? The first part of data should be on the first first(left) axis. The 2nd part should be on the 2nd vertical(right) axis.
0
votes
0answers
35 views

plot multiple data points by category and series?

I have multiple categories each with multiple data points for a single series, e.g. as shown below for series "Bear" and "Rabbit" Bear Cat A Cat B Cat C Cat D 2.09 5.73 4.72 ...
0
votes
0answers
34 views

microsoft excel scatter chart does not display data

I am trying to create a sctter chart in MS Excel 2013. I insert the chart, then I click "select data". (I know I'm doing this backwards from the way it is usually explained, but I need to do it this ...