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

**2**

votes

**1**answer

31 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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**0**answers

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

**0**answers

46 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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

32 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

**0**answers

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

**1**answer

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

**0**answers

22 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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

33 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

**1**answer

26 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

**1**answer

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

**0**answers

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

**1**answer

31 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 ...

**0**

votes

**0**answers

49 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

**0**answers

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

**4**answers

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

**0**answers

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

**2**answers

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

**1**answer

38 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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

52 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

**1**answer

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

**1**answer

131 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

**0**answers

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

**2**answers

94 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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

153 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

**0**answers

24 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 ...