Questions tagged [excel-charts]

In Excel, you can create graphical representations of your data in your spreadsheet in charts.

Charts are visual representations of worksheet data. Charts often makes it easier to understand the data in a worksheet because users can easily pick out patterns and trends illustrated in the chart that are otherwise difficult to see.

Different types of charts serve different purposes.

Pie Charts -- are used to show percentages. For example, a pie chart could be used to show what percentage of your total daily calorie intake is represented by one quadruple cheese and bacon hamburger.

Column Charts -- are used to show comparisons between items of data. Each column in the chart represents the value of one item of data. An example of this would be to compare the calories in a quadruple cheese and bacon hamburger with the calories in a glass of water and a bowl of beet greens.

Bar Charts -- are very similar to column charts, except they run horizontally on the page instead of vertically like column charts.

Line Charts -- are used to show trends over time. Each line in the graph shows the changes in the value of one item of data. For example you could show changes in your weight over a period of months as a result of eating a quadruple cheese and bacon hamburger every day for lunch.

456 questions
-1
votes
1 answer

Set Chart Series Name to Table Column Name instead of Series1,2,3,

With Excel 2010 I have the following code that creates a chart("BMS Data Chart") on a separate sheet from data from a table ("BMS_Data"). All works well except the Chart Series Names are Series1, Series2, etc... How can I use VBA to set these…
VBANewbie
  • 17
  • 1
  • 10
-1
votes
3 answers

How to Set Range of Table Data for use with Chart

Using Excel 2010 I am trying to create a chart on Sheet1 using partial data from several different tables. In the below example I am just trying to pull the data from one table as a start. I seem to be having difficulty setting the range of this…
VBANewbie
  • 17
  • 1
  • 10
-1
votes
2 answers

Excel: chart x-axis label

The current excel line chart has the following x-axis labels: 2010Q1 2011Q1 ... 2016Q1 How could I format the chart so the data from 2010Q1 - 2016Q1 remains, but the labels look like this instead: 2010Q2 2011Q2 ... 2016Q2
heyitsme
  • 33
  • 7
-1
votes
1 answer

Set min/max value of the X and Y axes in an excel chart through vb.net

As the Title suggest, I need to find the way to set the maximum and minimum value for the X and Y axes of a chart created through a vb.net code. This is the part of the code it should be inserted in: With ws …
maze11
  • 11
  • 1
-1
votes
1 answer

How do I create chart in Excel 2013 based on one column

I typically use Google Sheets and am very familiar with how to do this, but I'm forced to use Excel 2013 for a job. Here's what I need to do and I'm hoping someone can help. I have a worksheet with column "I" with the header "TEAM MEMBER" which…
Michael
  • 3
  • 1
  • 3
-1
votes
2 answers

How Can I Flip an Axis WITHOUT Visually Flipping a Chart

I have a chart in Excel which looks like this: The problem is that with my data, 100 is the lowest possible rating whilst 1 is a much higher score. As such I want the chart to have 0 at the top of the vertical axis and 100 at the very…
Studiumcirclus
  • 69
  • 4
  • 11
-1
votes
1 answer

How to put excel charts on C# wpf

By using Microsoft.Office.Interop.Excel, I can create the excel chart on my C# program and extract to excel file. But I want to directly put the chart to C# wpf. If it's not possible, can anyone suggest a simple charting library/dll for me.
Will
  • 155
  • 7
-1
votes
1 answer

Regression Line in different Excel Charts

I have the following Excel spreadsheet: A B C D E F 1 X-Values Y-Values 2 Year Revenue X-Ø Y-Ø (X-Ø) x (Y-Ø) (X-Ø)^2 3 2012 10…
Michi
  • 4,663
  • 6
  • 33
  • 83
-1
votes
1 answer

Hide data points in Excel if #N/A

I have a chart in Excel based on the data My problem is that I want to hide the data point at #N/A. The use case is that sometimes there will be a country, but I want the user to be able to disable/enable each country and I want the chart to…
Jamgreen
  • 10,329
  • 29
  • 113
  • 224
-1
votes
1 answer

Excel graphs x-axis

I have a series on data I'm plotting on a graph in excel. I want the x-axis to be dates, with the first date starting on 17 October 2012, the next date being 31 December 2012 and from there on the dates being 31 December every year. Is it possible…
-1
votes
1 answer

Excel non-continuous data points (Power Pivot)

I have a pivot table with some data points like this: To display a line graph i need y-values for every point, so i formatted the table to insert 0 in every cell with no value, which gives me this: What i need is a way for the pivot table to just…
TobiasKnudsen
  • 527
  • 2
  • 9
  • 29
-1
votes
1 answer

How to Put Two Sets of Data on One Graph in Excel

Date Issue redmeption App Date Issue redmeption App 21-Nov 891 200 523 28-Nov 660 179 302 22-Nov 607 125 423 29-Nov 712 165 420 23-Nov 456 165 422 30-Nov …
-1
votes
1 answer

Getting values from Excel graph

How can i get a value from an Excel graph? Meaning the Y-val of and X which isn't in the input data. For example in the graph - get the value for x=2.5? Example
D. Marks
  • 1
  • 1
-1
votes
1 answer

How can I add labels onto the pie pieces that are large enough to contain them, and alongside those that aren't?

I've got simple bogus data that generates this Excel Chart: This is the code: object misValue = System.Reflection.Missing.Value; //add data _xlSheet.Cells[11, 11] = ""; _xlSheet.Cells[11, 12] = "Student1"; _xlSheet.Cells[11, 13] =…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
-1
votes
1 answer

Creating upper and lower bound slopes to a linear equation statistically

The following graph represents my dataset, it is change in strain (y axis) and change in temperature (x axis) As you can see it is a linear relationship, I am wanting to create upper and lower bound thresholds in a robust statistical manner. Below…
1 2 3
30
31