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

learn more… | top users | synonyms (3)

2
votes
1answer
29 views

Stacked column chart in Excel

I have data in a sheet like the image below. The relevant portions are subtasks, shown in column B, subtask times, shown in column I, and daily totals, shown highlighted in green in the row at the ...
0
votes
0answers
11 views

Spreadsheet using data connection plots line graph points as zero

I have an Excel 2010 spreadsheet that uses a data connection to transfer data from another Excel 2010 spreadsheet. When I try to draw a line graph of date (column A) against ammonia (column I), all ...
0
votes
0answers
14 views

How can I create multiple charts based on a series filter using PivotChart?

I have a pivot table/chart displaying sales(value) by week(axis). I can add the branch to the legend and get one chart that displays the sales by week by branch. The problem is that I have 100 ...
1
vote
1answer
10 views

stacked area chart with secondary data range

What I have is this: and I am trying to achieve this: Using Calc 5, how do I manage the second column to be recognized as secondary data range?
0
votes
0answers
15 views

Excel Chart Title - how do I change font size when using cell reference?

I have a chart in Excel with the Title linked to a cell =REPORT_PAGE!$A$1 The formula in A1 looks like this: =ProductName & ": Project Performance" & CHAR(10) & "SPI: " & ...
2
votes
0answers
30 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 ...
0
votes
0answers
7 views

Asana Project progress by User

In Asana, you have a "Progress" tab for each project, where you see a chart, that tells you how many tasks are open, how many closed and so on. You are able to exclude some sections. As far as good. ...
0
votes
1answer
28 views

Drawing a chart on Excel [closed]

Is it possible to have a chart with left x axis top Y axis all on same chart? I tried switch the value of X and Y but it does not change the location of and y axises.
1
vote
1answer
22 views

Excel 2013 line chart vs previous excel

in my earlier excel chart I could check the "High-Low Lines" box in the Format Data Series box options tab. What is the 2013 version equivalent? I am trying to put the lines on the chart to be ...
1
vote
1answer
31 views

Swap X and Y axis table

I want to create a chart that has on X axis the time and in the Y axis the complexity. Then, in the same chart I have to put the time and the complexity of two different tests. Thus, I created a ...
0
votes
3answers
28 views

Attempting to make a multi-column graph

I am trying to make a column graph where the y-axis is the mean grain size, the x-axis is the distance along the transect, and each series is a date and/or number value (doesn't really matter). Here ...
2
votes
0answers
20 views

How can I make (in R) a network map that displays in sequence as a user clicks? [migrated]

There's this great network chart that displays sequentially. It looks like this: So it's clearly a force network chart... looks like D3 (though I can't tell for sure). How could I build something ...
0
votes
0answers
45 views

How do I program a excel chart to auto find or tell me the % likely for the next line?

Basically, I'm trying to find a way to get my excel file to tell me what is the % likely the next line is going to be a given set of numbers. https://www.dropbox.com/s/bd4hgyt886p86kk/Data.xlsx?dl=0 ...
1
vote
0answers
20 views

How can I supress zero values in a LibreOffice line line chart? [duplicate]

I'm making a line chart counting users of various releases of a piece of software over the years. This is a very spiky line chart, where as new versions come into existence and then retire, lines ...
0
votes
0answers
23 views

Trying to show a month to month trend with several locations (10) with 6 different trends

Location Criteria 1 Criteria 2 Criteria 3 Criteria 4 Criteria etc... Location name Jan 12 10 5 2 0 Feb 2 5 3 ...
3
votes
1answer
25 views

Is it possible to scroll through a chart in Excel?

Imagine that you have a dataset to which an additional measurement is added each day. In Excel, this could be a table to which additional rows are added. Imagine that you plot the time evolution of a ...
1
vote
1answer
31 views

Manually “drawing” line graph chart and export data

I would like to manually create a line graph and then sample the created line to generate a data series from it. Basically I have an idea, what a plotted values should look approximately and would ...
0
votes
0answers
30 views

Change line style for missing values in EXCEL

I'm plotting a chart where some of my lines contain missing values. I managed to interpolate using Select Data -> Hidden and Empty Cells -> Connect data points with line. However, there's no way to ...
-1
votes
1answer
44 views

How to format/prepare plots for manuscript in scientific publications

Hllo All, A very simple question and I am sorry to ask it here, but I am having a big time with it to solve it..And here is the question again..I have few figures in .svg, .png and pdf formats..I ...
0
votes
0answers
21 views

How to make one column a stack in a cluster column bar chart in excel?

How do I make one column stacked in a cluster bar chart in Excel, please see "Mock Up" below. I can currently do the clusters quite easily and have seen this guide, but I haven't quite got my head ...
0
votes
0answers
27 views

How to correctly select or lay out Excel data for a chart?

I have a set of data regarding my recent Bitcoin investment and I'd like to plot growth on a chart. Unfortunately, with the way the data is laid out on my spreadsheet, I can't seem to get the chart ...
2
votes
2answers
72 views

How to do a conditional formatting in a table from a graph?

As you can see in this example below, I would like to be able to put in red the negative numbers that are in the table below the graph. I would like to apply a conditional formatting on this table ...
1
vote
1answer
34 views

Grouped scatter plot with interpolation in Excel

I tend to use other tools for data visualisation but have been asked to use Excel for a given plot. That is, I need to plot one column against another and separate the data into different lines by the ...
1
vote
1answer
29 views

How can I build a plot data in Excel without separating categories into multiple columns?

How can I plot the following data where each category is colored differently in excel? category | datetime | score -------------------------------------- foo | 2016-01-01 00:00:00 | 1 ...
0
votes
0answers
20 views

How to create an overlapped area chart just like picture below on Mac version excel?

I need to create charts like this for each price band. The blank and colored areas combined should be equivalent to the total share of products within that price range. I m using Mac so its a little ...
1
vote
1answer
20 views

Excel chart showing text over date

I am trying to show a chart based on a data set similar to this one. My intention was to show possible patterns of the Items over a period of dates. Does somebody know how I can create a chart ...
1
vote
1answer
32 views

Connect data points around missing data with different style of line on graph

I have an libreoffice-calc spreadsheet with some results of daily measurements. Some days are missed for some reasons. I want to create a graph showing this data, and I want to highlight all missed ...
2
votes
1answer
25 views

Pie chart in Excel 2010 is not reading/displaying the number 0

I am trying to create a very basic pie chart in Excel with the following data: Score Quantity 0 5 1 5 2 6 3 3 4 4 5 ...
1
vote
1answer
21 views

Excel charts flickering/moving on screen

I previously posted this in Stackoverflow but was informed that this is a more relevant place...http://stackoverflow.com/questions/34203652/excel-charts-flickering-moving-on-screen We have a ...
1
vote
0answers
13 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 ...
0
votes
1answer
30 views

Excel Chart Series: column has data, but dialog box shows zeros

Excel 2013. My machine is a 64-bit running Windows 7. I have an .xslm file with a chart. The chart is created from a few columns of data. The data in the columns is populated by reading data from a ...
1
vote
0answers
48 views

How to hide zero values from an excel 3d surface graph?

I am currently trying to put together a 3D surface graph in Excel 2013. Currently, it looks like this: The area on the left is the proper chart - displaying actual data I have. The area on the ...
0
votes
0answers
18 views

Excel 2013 Chart showing numerical axis instead of dates

I have a bar chart that is based on a table with monthly figures (eg. 1/11/2015 | 1/12/2015, etc). When I create the table, it works perfectly with the Month and Year along the X-axis. However, I have ...
1
vote
4answers
84 views

Manually adjust axis numbering on Excel chart

I want to adjust the X axis of my scatter diagram according to my diagram points in MS-Excel 2010. I have seen in some guides that I can change it by editing the "Axis Labels" in "Select Data". As you ...
0
votes
0answers
26 views

can I somehow save the specification of a chart as kind of template

I have a LibreOffice Calc spreadsheet with 12 sheets, each sheet is one month. In column A I have entries of Category "Date" and in column B I have entries of Category "Time". I then make a Chart ...
2
votes
2answers
64 views

How to duplicate the Y-axis label of a chart to the other side

I have this chart in Excel with the Y-axis automatically placed on the left side of the chart. Aside from inserting a textbox, is there any other way to duplicate that label to the other side or to ...
0
votes
1answer
37 views

Can I format the Y-axis in this way?

I'm using Excel version 15.15 on a late 2014 Mac Mini running El Capitan 10.11.1. I am trying to represent 3 things; Profit & Loss for Rates & FX and for Credit (two different asset classes), ...
0
votes
1answer
26 views

Excel Chart Axis Formatting

I want my axis on my charts to display numbers to the tenth. So instead of 2 or 3, I want the axis to read 2.0 and 3.0. Please help. I have already rummaged through the format setting and am lost.
0
votes
1answer
37 views

How to format stacked bar chart correctly

I'm trying to make a stacked bar chart for some transactions made within the year. Ideally, the x-axis is month, the y-axis is amount, and the stacks (layers) are vendor name. But I can't get it ...
2
votes
1answer
34 views

Pin line/arrow to bar-chart elements

I'd like to pin some lines in order to follow the movement of stacked 100% bar-chart elements. As you can see from the screenshot below Right behavior the arrow are more or less in the middle of ...
1
vote
0answers
50 views

Stacked Line graph line colors do not match legend

I made an interactive chart that shows different data, depending on which ActiveX checkboxes are checked. I created a few tables that would show different data by using a few nested IF statements ...
1
vote
1answer
38 views

Duplicate Chart in OpenOffice Calc without losing link to the sheet's data

I have created and formatted a chart and need the same one again to be filled with other data. The problem: In OpenOffice Calc 4.1.1, a chart's data is unlinked from the original data/sheet, as soon ...
1
vote
1answer
129 views

Dispersion graph in Excel

I need to draw a dispersion diagram in Excel, but that must be vertical, not horizontal. I have this table and need to graph the "Weighted" column: When I try, I get this horizontal graph: What ...
0
votes
0answers
55 views

Format datatable using VBA (values are as Double but String is needed for formatting)

urrently working on a vba script that makes charts automatically. I would like to add a datatable which is done using: .HasDataTable = True However I would like to show the values of series as ...
2
votes
2answers
93 views

Excel survey data pivoting, plotting and analysis

I have a set of data from Google forms survey. I ran into a problem representing the data for a specific question type, grid to be exact. So for example you get a question like this one: and ...
0
votes
0answers
23 views

Excel changing data order in chart

I have an excel chart with the source data sorted from largest % to smallest % by salesperson. However, the chart that is created from that data set is showing the data listed alphabetically in the ...
1
vote
0answers
70 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 ...
2
votes
0answers
26 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.
1
vote
1answer
151 views

Excel - X-axis issues when combining x-y scatter and column charts

I want to superimpose a column chart on an x-y scatter chart. I have done that by adding a series (for the column chart), creating a new y-axis for the values, etc. However, the x-axes don't work out. ...
0
votes
0answers
23 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 ...