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
vote
0 answers

Excel crash after Copy and paste Chart image

I Need to Copy an picture/image of a chart which is in another workbook (WbO), and paste the picture in a worksheet in this workbook (TWb), using Excel vba. I figured out a simple code to do this. The good thing is that the code works. Stepping line…
1
vote
0 answers

How would I use the Find function in VBA to get the address of a cell that I can use to SetSource some chart data?

I'm pretty new to VBA, so apologies if my code is a bit messy. I'm having a bit of trouble with using Find to get a cell address back. I want to find the row of cells based on the listbox value, and then find the address for the first cell of…
Mak12mill
  • 11
  • 1
1
vote
1 answer

How to reference "active/selected" chart data point in Excel using VBA

I am looking for a way to reference active/selected chart data point in Excel using VBA. Imagine I have a line chart, which I would like to add an error bar to. But, I do not want to add error bars to the whole series, but only to ONE, selected…
Rafał Kowalski
  • 177
  • 1
  • 11
1
vote
0 answers

Hide Text Axis and Have Chart Readjust in Excel

I have the following table in excel: A B C 1 Object 1 100 100 2 Object 2 0 0 3 Object 3 100 100 4 Object 4 0 0 When I create a stacked bar chart with this values I…
enri
  • 11
  • 1
1
vote
1 answer

Change Series plotorder or legend entry order across different ChartGroups

Office 365 I have a combination chart in powerpoint. One series is column type, and the other three are lines. They are all in the primary Y axis. The X-axis is of category type (text labels) Here is an example on how Powerpoint is structuring…
Jose R
  • 738
  • 2
  • 10
  • 26
1
vote
0 answers

VBA charts not refreshing with refresh.all or if I loop through the charts

Hello I am trying to write a script that will call a function to refresh charts every 30 seconds. The first function provided works by simply telling the machine to run my other function "RefreshCharts" after 30 seconds. The problem I am having in…
1
vote
0 answers

Chart series being truncated to 16,384 values after modifying the values

I'm using Excel 365 I have a chart that has XY scatter data -- potentially upwards of 20,000 values. Outliers in the data are so far out of the norm that the range gets compressed and the chart becomes less meaningful. I want to clean up these…
1
vote
1 answer

Chart from dynamic range

I was making a graph from a dynamic chart using VBA. The Chart is coming as expected, however I want the X axis to show X values from columns only that contains data. Here it is showing all the columns including those that are not having any…
1
vote
0 answers

Creating a pivot chart without displaying the column by which the pivot table is sorted

I am trying to display a number of total sales for each worker on a pivot chart. I need to sort the data in the table according to total sales however I don't want to display the total sales on the pivot chart. Is there a way to achieve this? Total…
1
vote
1 answer

Missing portion of the graph in VBA when 2 or more separate graphs are plotted when same data are used

When I plot my chart using one set of data(current 1), the graph shows the correct output. However when I plot 2 sets of data concurrently(current 1 and current 2), part of the graph is missing(circled in red) for both data consisting of current 1…
cena
  • 410
  • 1
  • 4
  • 12
1
vote
1 answer

VBA Object variable or With block variable not set

The point of this code is to create a chart in a new worksheet, which it does. After this, when I click the button to generate the chart again in a new worksheet named the same, it's supposed to delete that sheet and create a new generated chart.…
1
vote
0 answers

Change a range for a specific series in a chart using vba

I am trying to repurpose an existing series that I have in multiple charts-there are well over a hundred charts in one worksheet, so trying to do via vba. Warning: Very new to VBA! In each chart, Series 1 references data in columns A-C, but…
Suzanne
  • 11
  • 1
1
vote
0 answers

UserInput data onto chart

I want to lay the users input values onto the scatter chart. I've managed to get it to work using "Sheet1" in the code, however in reality the sheet tabs are going to vary with numbers etc. What can I change within this code to make look at the…
Wales
  • 11
  • 1
1
vote
1 answer

How to add text to a chart by excel macro?

Using the following codes to add text to a chart by excel macro? When compiled to a module, it shows "object doesn't support this property or method", any suggestion or revised codes really appreciated. Thanks Set myDocument = Ch.Chart …
together
  • 413
  • 2
  • 11
1
vote
2 answers

Pivot chart formats

very VBA-knowledgeable people, I have a pivot chart going on, and I wrote a sub to format the series representation. This chart contains four series and is connected to a slicer. The problem is that the formats aren't working for some of the…
SSGrace
  • 37
  • 6