Questions tagged [charts]
Graphs, charts and other graphical methods for showing data and their relationships.
1,565
questions
3
votes
1
answer
39k
views
Adding text axis labels to excel scatter chart
I have a Spreadsheet with data like this
Label Data
PA_1 1
PA_2 2
PB_1 3
with hundreds of rows.
I want to create a scatter graph where the x-axis contains the names in the label column.
Instead, ...
3
votes
1
answer
5k
views
1/3 octave band chart in Excel?
I want to create a 1/3 octave band chart in Excel 2007 but I can't find the way to do it. Excel only allows me to put the 'x' axis into a logarithmic one, but the scale for 1/3 octave band is not this ...
3
votes
2
answers
6k
views
How can I format data bars based on value in Excel 2010?
I have a dataset containing values from 0 to 584. I would like to illustrate this using data bars, but I would like the databars to be green when the number is greater than 150, and red when the ...
3
votes
3
answers
2k
views
Manually "draw" data for chart, output to CSV [closed]
I need a service that will allow me to draw a chart line by hand and generate data points for what I drew. This might sound crazy, but I need some data (preferably in CSV output) that will only ...
3
votes
1
answer
5k
views
Ascii-art graphs in Linux
I have a text file that represents the runtime of a specific script, with each line representing one run:
141
124
156
204
498
512
444
374
189
120
143
132
One can see that the section that I pointed ...
3
votes
2
answers
20k
views
Splitting data into multiple series' in Excel Graph
I have data from a csv formatted as such:
StartTime EndTime Duration Type
--------- ------- -------- ----
43:04.7 43:06.9 2200 long
43:06.9 43:08.7 1825 middle
43:08.7 43:...
3
votes
2
answers
2k
views
Timeline chart in Excel
I'd like to see a timeline of events from a database in a "timeline chart", that should look like this:
I've made me a small c# program that paints this onto a Bitmap, but that isn't the way to go.
...
3
votes
5
answers
356
views
Any good 'how to...' resources out there? [closed]
Does any one have any good resources - websites or books, when it comes to creating (mastering) simple to complicated graphs or charts?
I've reached the point where I need to do more than tables. ...
3
votes
2
answers
664
views
Plot the area between two curves
I have a function with a parameter z similar to the above one:
y = sin(x+z)
How can I plot the values of y as a function of x and all the possible values of z in the [0.1, +0.1]?
I want to graphic ...
3
votes
2
answers
627
views
Formatting an excel chart with 2 columns in the horizontal axis
I have data in excel where I want to show 4 to 5 values per month. The horizontal access I would like it to be very easy to read. So for the horizontal axis I would prefer to have a month and year and ...
3
votes
2
answers
208
views
Dual y-axis in chart
I am trying to make a combo chart (bar and line). Usually, a simple way is to add a dual y-axis. However, sometimes this could be confusing. Recently, I came across some alternative options, and I was ...
3
votes
1
answer
9k
views
How to Change Orientation of Multi-Level Labels in a Vertical Excel Chart?
I have the following chart and I am not able to edit the first level of labels (membership, chapters, etc). When I go to Format Axis -> Alignment I can only change the orientation of the second ...
3
votes
1
answer
42
views
Excel - Dynamic Charts
I have a series that looks like SERIES('Data'!$C$140;'Data'!$E$138:$Q$138;'Data'!$E$140:$Q$140;2) and in order to make it dynamic I'd like to replace the endpoints with a cell that depends on the ...
3
votes
1
answer
825
views
Subscript in Excel bars
I used chart tools in Excel to draw some bars. As you see, some of the cells that name the categories include subscript characters, but when they appear in the legend, none of the characters are ...
3
votes
1
answer
784
views
Coding an Excel function to fill in data gaps
In Excel, I currently have the following scatter-plot and its corresponding data set for one of the series:
I am attempting to create some kind of function that will enable me to interpolate points ...
3
votes
1
answer
5k
views
Any way to make the following chart (pictured) in excel?
This is the chart that I had in mind. Similar to this chart, I have values for the amount of people that answered Agree/Neutral/Disagree to a specific question. Is there a way to center these answers ...
3
votes
1
answer
16k
views
Powerpoint - Stacked bar chart with wrong bar length
I'm using PowerPoint 2016 on Windows 7 to create a stacked bar chart of a Yes-no-question and I'm experiencing a very odd behaviour. When the left part of the bar graph (Yes) is set to 83% or less, ...
3
votes
2
answers
1k
views
How to do up a excel hair chart?
I'm trying to do up a chart (on excel), the chart that I have in mind is somewhat similar to the attached picture.
Data:
X-axis: dates (weekly data)
Y-axis: interest rates
Doing this, I can easily ...
3
votes
2
answers
5k
views
Export excel chart to png with certain dimensions
How do i export an Excel chart to a PNG image, defining the exact size of the resulting image file?
I need to export some excel charts to PNG to put them on a html page. Due to design restrictions, ...
3
votes
1
answer
2k
views
How to antialias trendline in Excel?
I have created a couple of line charts in Excel 2011 for Mac. The actual data line looks good and is antialiased in a nice way but when I then add a trendline it is jagged and ugly:
I have tried "all"...
3
votes
2
answers
10k
views
Three pairs of box whisker plots in one coordinate system
I need to plot in Excel 2007 something which looks like this:
Basically I want to plot 2 box whisker plots, then have some empty space and then again 2 box whisker plots, followed by empty space and ...
3
votes
1
answer
42k
views
A sensible way combine two stacked bar charts in Excel?
I have one chart that has several stacked bars with identical components - one for each category.
Each of the components of those bars can also be represented with a stacked bar chart, like the ...
3
votes
1
answer
525
views
Use of Excel 2011 to produce a line graph showing amplitude variations with distance
I have 2 columns of numbers:
Column A I want to be the X axis of a smooth line graph which goes through all of the data points which shows distance.
Column B I want to be the Y axis showing amplitude....
3
votes
1
answer
915
views
Best way to visualize graph on a text console?
I looking for a solution to visualize a graph on a standard unix text console. Speaking more precisely I need to visualize a graph of dependencies between files from specified set, those dependencies ...
3
votes
4
answers
43k
views
How can I create proportionally-sized pie charts side-by-side in Excel 2007?
I have a pivot table with two sets of data as follows:
2011 2012
Slice A 45 20
Slice B 33 28
Slice C 22 2
I am trying to present two pie charts side-by-...
3
votes
2
answers
11k
views
Excel: Bubble chart labels - use 4th dimension?
I've got a dataset that has 4 dimensions - lets say they're the following:
+------------------------------+
| Type | Amnt |Price| Quality |
+-------|------|-----|---------+
| A | 15 | 4.0 | ...
3
votes
3
answers
2k
views
How to visualize/graph a massive dataset?
I have a CSV file of data collected using Performance Monitor. It collected CPU usage at 5 second intervals for two weeks.
I need to be able to graph or visual the data in a way that'll help me ...
3
votes
2
answers
7k
views
Calculate the Y Axis interval for a chart
When creating a chart of, e.g. daily sales figures for the month. Does anyone know how to calculate a suitable Y Axis interval?
I've been looking at Excel which seems to choose nice intervals like ...
3
votes
3
answers
10k
views
Excel Graph: how can I show two values in the same bar? Not using stacked?
I've created some data for inventory items over time. Each item has two models (A & B), and the scale is (-) or (+). I've included example images of the type of graph (drawn) I'm aiming for, with ...
3
votes
1
answer
849
views
Excel 2007 Chart - Super Simple Chart what am I doing wrong?
I have two columns.
The first column begins with "Year" followed by well years (1999, 2000, 2001, etc.).
The second column has a title of "Revenue" and is contains revenue values ($12.1M, $13.2M, $...
3
votes
1
answer
5k
views
How can I fill a shape in Radar Chart?
I'm struggling to find a way to just fill one shape in a radar chart.
An example of what I would like to have is in the image.
I tried to start from a simple radar chart and then filling the shape --&...
3
votes
1
answer
1k
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 ...
3
votes
1
answer
4k
views
Add an area to a scatter plot in Excel
I'm desperately trying to layer an area chart on top of a a scatter plot in Excel 2013.
The scatter plot has been successfully used to visualize the deviation from the mean of different Key ...
3
votes
1
answer
45k
views
Excel 2013 Chart - Multiple Series on Pivot Chart
I have an Excel 2013 file that pulls data from a SharePoint list. The goal is to create a dashboard that can be refreshed easily and without formatting or updating formulas of any type.
The list/...
3
votes
1
answer
102k
views
Plot scatter graph in Excel graph with 3 variables in 2D
3 Columns of Data:
Date (from 1st till 31st)
Variable 1
variable 2
I want to make a simple graph where Variable 1 range is X axis and Variable 2 range is Y axis,
I plot the date on the graph so: ...
3
votes
1
answer
2k
views
Print an organizational chart to PDF from JSON data?
I've been searching for a few days and haven't found quite what I need yet.
I've got a tool I'm working on that displays a person in a sort of visual hierarchy of the company (from the CEO down the ...
3
votes
2
answers
16k
views
Excel graph - two lines, one axis with date
I want to make Excel chart that shows my accounts' balances in time.
I have 2 bank accounts and I have all transactions saved in Excel. The data's format is:
Column A Column B Column C Column ...
3
votes
2
answers
572
views
Simplest Automated Analysis and Chart Generation Tool? [closed]
Are there any products that can take a CSV of info, and quickly generate commonly-asked for info? I'm wondering if there's any way easier than pulling this into Excel or Matlab and manually doing all ...
3
votes
2
answers
2k
views
Application to generate graphs from MySQL table [closed]
I am looking for a solution to generate graphs from MySQL tables (local MySQL server).
I would like it to work on Windows, and not be based on a server (like a PHP server). This is just basic stuff: ...
3
votes
2
answers
14k
views
Create progress bar or milestone type graphs in Excel 2007
I want to display project progress in Excel 2007. Is there a way to show a progress bar like graph filled for completed percentage and empty until end date for a milestone or the whole project? It ...
3
votes
0
answers
598
views
When I try to edit Y-axis limit on LibreOffice, the data in the chart disappears
Has anyone encountered such an issue? Am I missing something?
When I choose axis limits manually from Right Click > Format Axis > Scale, the data in the chart disappears or gets hidden. I am ...
3
votes
0
answers
3k
views
Dynamic Horizontal Axis Crossing Excel Bubble Chart
I'm attempting to make a 4 quadrant bubble chart in Excel to compare some competitor companies. I've input all my data from a pivot table, with 4 slicers to filter what the bubble chart is showing you....
3
votes
0
answers
272
views
Weird watermark when pasting Excel graph as picture with gridlines
When I paste an Excel 2016 graph as an image in Word (also 2016), if the graph has gridlines, the image displays some kind of watermark in the center, like this: .
I know the problem are the ...
3
votes
1
answer
3k
views
Can I automatically sort a grouped and stacked pivot chart by a sum of values without showing this on the chart?
I am working with data in groups in Excel. I currently have a pivot table and chart set up with:
Rows: symptom name grouped into one of four international severity grades
Columns: four datasets - ...
3
votes
1
answer
3k
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 ...
3
votes
0
answers
580
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.
3
votes
1
answer
3k
views
Creating a line graph in excel with changing/result cells
For a project we are creating care packages for the homeless. I am trying to figure how many kits to make for the least leftover material as the things we are putting into the packages are sold in ...
3
votes
0
answers
1k
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 category?...
3
votes
0
answers
2k
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 '...
3
votes
5
answers
132k
views
Excel or PPT: How to have two pie charts, but one legend
I would like to design a slide that shows two pie charts of the same size side-by-side, but with a single legend that is centered on the page beneath both charts. I can easily create one of the pies ...