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

learn more… | top users | synonyms (3)

0
votes
0answers
5 views

Stacked column chart in Excel

I don't know if this is actually is possible, but I think you will know :) I have data in a sheet like the image below. Is it possible to add a stacked column chart, one for each day. The column ...
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
13 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
29 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
44 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
20 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
83 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
63 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
33 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
127 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
69 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
150 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 ...