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
0
votes
1 answer

Return blank value on graph when datasource is empty in excel

I have an excel file which calculate a person's monthly score/grade. My problem is, I don't want excel chart to return "0" value on chart whenever my datasource cell is blank. Is it possible ?. Thanks!
Jgz Tradamus
  • 21
  • 1
  • 1
  • 6
0
votes
0 answers

How do I change secondary horizontal (value) axis font to white?

I have tried to use the Format.TextFrame2.TextRange but this does not work as it returns a Microsoft.Office.Interop.Excel.TextFrame2 object that contains text formatting for the specified chart element. It is read only. I need to set the Secondary…
user3168684
  • 53
  • 1
  • 5
0
votes
1 answer

Force chart to display data in the order it is in the cells

I have set up some data in Excel cells like this (this is just a small sample): +-+------+------+------+------+ | |Jan-12|Jan-13|Feb-12|Feb-13| +-+------+------+------+------+ |a|59353 |36543 |46535 |45672 | +-+------+------+------+------+ |b|70002…
1252748
  • 14,597
  • 32
  • 109
  • 229
-1
votes
1 answer

Filtering out chart categories

I've been trying everyway I can to create a vba code that deselects a few categories if they aren't used. In this case I have a graph from January to December, and I want to deselect the months that haven't arrived yet. I have one cell, that tells…
Liuchess
  • 1
  • 2
-1
votes
1 answer

VBA Scatter Chart Line Color Access

Is there a way to access the color of a new series line in a scatter chart that is created dynamically using VBA? I want to take the color of the line of the new series and put it as the background of a cell near where the data is for the new…
cspencer
  • 3
  • 1
-1
votes
1 answer

Loop to make charts from separate ranges/tables

Do you know how to make a loop in VBA to insert a chart for for example every range containing string "%" or just for every separate range as shown on picture? I tried using such code as shown on the picture but it only adds chart for the first…
-1
votes
1 answer

remove specific legend apache poi excel graph XDDFChartLegend

i am using apache poi 5.0.0 version i have generated a graph in excel using the data and i am able to see the legends in the bottom of the graph. There are six legends shown. Now i want to remove two specific legends without removing them from the…
-1
votes
1 answer

VBA Code for dynamic Range to update Stock Chart

I am VBA Learner and working with Stock OHLC Chart, looking forward with experts for my problem. Sheet 2: Has data in Column A to E (Column has header as Date, Open, High, low and Close). Sheet 1: having Chart and only want to modify range. Range…
-1
votes
1 answer

Fill two Excel charts using a two arrays

I have asked this question before and I am grateful for the help I received but the problem persists. I am trying to plot a Shear-Force and Bending-Moment diagram calculated from the loads. I create two arrays of points which I pass over to two…
hemis
  • 45
  • 1
  • 2
  • 11
-1
votes
1 answer

Get sheet name where selected chart is located

While looping through all charts in the book - how can i get name of the sheet on which my chart is located ? I have folowing code in VBA Excel: Sub mytest() Dim ws As Worksheet Dim Ct As ChartObject Dim Wb As Workbook Set Wb =…
VBA_fan
  • 1
  • 1
-1
votes
1 answer

How to make comparison chart to display data from two workbooks on each worksheet that have the same name

I have a difficult task. I am not sure if anyone out there can help me. Please read my concerns: #1 I have "2" workbooks name: Unemployment_Rate GDP_Annual_Growth_Rate_% #2 in "Unemployment_Rate" workbook. I have "1" Master worksheet and "181"…
Matrix
  • 9
  • 3
-1
votes
1 answer

Excel using a graph trend-line formula to calculate y values from x values

I have a data set which needs to be offset by another data set. My initial set is a sample being compressed, with the data being X = load (N), Y = Compression displacement. My offset is the shift in the testing setup which is again measured in X =…
-1
votes
3 answers

How To Make Line chart,so that the line chart does not overlap

Hi, I have trouble with my line chart here, the line chart is overlaping and it makes another line is not visible or covered up.
JuMa
  • 57
  • 1
  • 10
-1
votes
1 answer

Loop through worksheets containing graphs, copy both ChartObjects into another sheet

In my Workbook, I have multiple worksheets each containing 2 graphs – I want to loop through these sheets copying ChartObjects(1) and ChartObjects(2) side-by-side into another sheet named "Graphs". To clarify, the worksheets that contain 2 graphs…
TheEndUK
  • 33
  • 5
-1
votes
1 answer

Creating Multiple Candlestick charts from a csv file

I am trying to create multiple candlestick charts for given date ranges which I have a list of in Excel. I have OHLC daily price data and need to use this data to create roughly 1100 charts. I would like these charts to be in a printable format…
Ed Lee
  • 27
  • 5