Questions tagged [charts]

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

Filter by
Sorted by
Tagged with
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, ...
VBwhatnow's user avatar
  • 2,219
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 ...
Shivoham's user avatar
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 ...
dwwilson66's user avatar
  • 1,749
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 ...
Ambidex's user avatar
  • 385
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 ...
dotancohen's user avatar
  • 11.5k
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:...
user avatar
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. ...
Axarydax's user avatar
  • 1,237
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. ...
RocketGoal's user avatar
  • 1,528
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 ...
Luís Marques's user avatar
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 ...
Shane S's user avatar
  • 89
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 ...
Fayyaz's user avatar
  • 33
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 ...
OzzyKP's user avatar
  • 119
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 ...
user919640's user avatar
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 ...
user892463's user avatar
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 ...
David A. Lee's user avatar
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 ...
Mark's user avatar
  • 31
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, ...
RikuXan's user avatar
  • 334
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 ...
Cedric Yang's user avatar
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, ...
tohuwawohu's user avatar
  • 10.7k
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"...
d-b's user avatar
  • 814
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 ...
Chris's user avatar
  • 213
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 ...
user255759's user avatar
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....
Bryan's user avatar
  • 31
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 ...
andreypopp's user avatar
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-...
Andrew Doran's user avatar
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 |   ...
growse's user avatar
  • 2,661
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 ...
Chris Thompson's user avatar
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 ...
user avatar
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 ...
RocketGoal's user avatar
  • 1,528
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, $...
computergeek's user avatar
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 --&...
spartan15's user avatar
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 ...
Jas's user avatar
  • 678
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 ...
danpo's user avatar
  • 33
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/...
KingOfAllTrades's user avatar
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: ...
PFrederic's user avatar
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 ...
Rob's user avatar
  • 2,382
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 ...
Kamil's user avatar
  • 31
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 ...
Mahmoud Al-Qudsi's user avatar
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: ...
Matthieu Napoli's user avatar
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 ...
user48604's user avatar
  • 543
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 ...
Dainius Stankevicius's user avatar
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....
user402253's user avatar
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 ...
yuyu2809's user avatar
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 - ...
Rory's user avatar
  • 585
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 ...
Nischal's user avatar
  • 31
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.
edcon's user avatar
  • 31
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 ...
user avatar
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?...
user905686's user avatar
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 '...
brokkr's user avatar
  • 174
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 ...
user202527's user avatar

1
3 4
5
6 7
32