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

learn more… | top users | synonyms (3)

1
vote
1answer
27 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
60 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
45 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
26 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
34 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
94 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
0answers
156 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
28 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
251 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
30 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
163 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
62 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
33 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
64 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
47 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
122 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 like:...
1
vote
1answer
85 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
297 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
104 views

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

Currently 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
142 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
24 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
147 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
38 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
542 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. ...
1
vote
0answers
82 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
1answer
77 views

Creating a distribution chart in Excel

I would like to replicate in Excel, which groups hundreds of occupations under 12 major job categories, and plots them according to number of jobs and probability of computerisation. I currently ...
2
votes
2answers
96 views

How to use a number range as the x-axis on an excel bar chart?

I have some data that I want to translate into a bar chart in Excel, however I am unsure on how to make it so my x-axis is in the correct format I need it in. Here is the Excel data: And here is ...
0
votes
0answers
31 views

Graph of large data set of 5 billion records

I have a csv file of more than 5 billion entries in it. I want to create a line or area chart for this data. Which software I can use to do so. The file size is 34GB.
1
vote
0answers
78 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 ...
0
votes
2answers
22 views

Avoiding one broad column in PivotChart in Excel

When I have a PivotChart in Excel that only has one column, that column gets unnecessarily big and broad. How do I retain that size somewhat, even though its only one column?
-1
votes
2answers
125 views

Creating a even time axis in Excel when you have a uneven time values

I am creating charts for the valuation of startups, based on new funding rounds. I want a time axis (X) that has evenly distributed time, even though the data points may not be evenly distributed. ...
0
votes
0answers
31 views

Excel PowerPivot m2m with time series

I have a dataset which I have simplified a bit for this post. From the image you can see that I have two data tables. They essentially list the estimated output from two 'facilities', and the actual (...
0
votes
1answer
103 views

Removing dates when there is a year gap between data in excel graph

I am trying to create a share price graph with historical share price and future estimate price in one year time. When i plot the graph I am using the historical prices for the year , which is not an ...
0
votes
0answers
34 views

Get time plotted data to automatically line up in correct date order regardless of blank cells

I have a set of data points plotted over time. Time is plotted monthly and the results for Suplhate (example given) are plotted quarterly. Results are entered in the same month every quarter for each ...
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 ...
1
vote
1answer
154 views

Excel Chart with data points not in chronological order

Say you have total monthly spend for 36 months and you want to display it in a bar graph to show all the spend for the 3 Januarys, then all the spend for the 3 Februarys, etc. When I sort my data ...
0
votes
1answer
31 views

Change linked data in a chart embedded in Word

I have set up six charts on a page, so that they're all the same size and formatting. But at the moment there are only two distinct charts and each one has three versions. I did this because I didn't ...
0
votes
1answer
120 views

Histogram over Time?

I am trying to track the progress of a similar variable on a number of (several thousand) objects over time. I have several snapshots of data in the following form, but I want to show the progress ...
0
votes
0answers
25 views

Excel chart referring to non-existent sheet

We have an Excel Report generated by a Java Process with all charts and jazz. The report has 10 tabs. The very first report has a "Walk Chart" generated. Unfortunately, the chart is displaying ...
0
votes
1answer
467 views

How do I keep formatting on an Excel 2010 Pivot Chart?

I have some VBA code that runs a SQL Query, dumps it into an Excel 2010 spreadsheet and refreshes the 2 Pivot Tables based off the data. I also have 2 Pivot Charts based off of the Pivot Tables, and ...
1
vote
1answer
48 views

How can the placement of data points in a graph be adjusted?

As part of an important presentation, I've created the following diagram showing statistical data over 5 periods of time. The data for each period consists a pair of a bar charts with a ...
0
votes
3answers
2k views

How to get a particular y value on a graph from Excel

Here below is my Graph: Let's say I have a reading of 1.02 ml (the x-value from the graph) from my buret, how do I find the corresponding y-value?
1
vote
1answer
116 views

Excel Charts: Is it possible to add specific text to the bars on a chart?

I have a chart which shows the daily purchases of each day in August 2015 against the daily purchases of each day in August 2015 in the bars, the lines show the total purchases in August 2014 for each ...
0
votes
1answer
247 views

Excel 2013: Adding a formula / function to a chart legend

I have a chart in Excel with three legend entries. Each of them contains the word "Umsatz" and all of them are linked to cell values. Now I would like to remove that word from the entries with a ...
6
votes
4answers
277 views

How to setup stacked bar chart to graph medication doses?

My Mom is sick (cancer) and my Dad has been writing down the times that he has administered pain medications to her. He asked me to plug it into a spreadsheet and chart it so he can visualize trends ...
0
votes
1answer
87 views

Odd issue with Excel pie charts

I am having a weird issue that I was hoping was a quick fix with Excel 2013 for a pie chart. However, I can't figure out what's wrong! I am attempting to make a pie chart out of a column that looks ...
1
vote
1answer
874 views

How to Fix Excel Graph to stop drawing line when data ends (not auto extend line to zero)?

I am using Excel 2010. I am trying to graph actual expenditure data (a solid line) and extend that graph into the future (a dashed line). I have a 5 column sheet. The first column is a date column ...
3
votes
1answer
157 views

Excel 2010 create pie chart with labels which apply to more than one segment

I want to create a pie chart with data labels which refer to more than one segment. I have found an approximate way of doing this - these are the steps I followed. My data looks like this: I want ...
1
vote
2answers
5k views

Add Baseline to simple Excel chart

I have a simple Excel spreadsheet tracking weight loss. I have a column with dates and another with weights. I made a simple chart with both columns as data sources (dates are x, weight is y). That ...
-1
votes
2answers
1k views

Connecting multiple series on Excel scatter plot

I am trying to create a scatter plot with multiple series and have them connected. My data has multiple Y values for a single X value. There are 4 X values and 7 Y values for each X value for a total ...