excel chart

Hello, I'm new here and I need help. I have a very important meeting at my company on Tuesday which can possibly give me the promotion that I have been waiting for. The thing is our CEO is going to convince stakeholders of the company about something and for that he has chosen me to accompany...

Hi everyone, I have a pivot table as shown in the first image with the fields shown in the second image. I would like a chart to only show the "Attended" values, but I am uncertain on how to achieve this. Could you please help? THank you

I have a table where sales data gets updated based on user selection. A chart is prepared from this table. (image attached). 1. If user selects monthly on pivot slicer, sales data for month will appear and sales data for quarter will show #NA error. 2. If user selects quarterly on pivot slicer...

I am having chart based on power pivot where values for all the months are updated based on slicer Selection. (E.g. Profit, Profit%.) I am currently using this number format "#,##0_);[Red](#,##0)" for chart labels which is available by default in excel. This format hides decimal values...

I have a large excel workbook with dozens of charts. What I now intend to do is copy all these charts and paste them to Word document. In the mean time, I want the source data embeded in Word doc so that others can access the source data. The problem is that every embeded chart in the doc...

Hi, Could you please help me delete the pivot data highlighted from the chart only?AB3Row LabelsAverage of % DIFF B/W M&F4470,16%5F0,43%6130,43%7M-0,43%86-0,43%9Grand Total0,16%

Hi all, Hope you are doing well. I'm coming on this forum because i really need your help and i'm a big beginner with VBA. I have 3 charts : -Chart1 -Chart2 -Chart3 I want to update multiple series ranges on these charts with a one VBA code like below : Chart 1 -Update "Serie 1" with the...

Hello. I have the code below that when the user inputs a value on a certain cell and logs it via a button, this is called to populate a simple line graph. At the beginning of each day the graph area is empty. I have tried to add a second data series but nothinh seems to work and can't figure out...

I'm trying to edit a single label on the X-axis of my Excel chart. I have a simple time series chart with date labels on the x-axis. I have chosen a single letter for the month. I want to edit the first month of the year (J) only and change it to 2020. The next label should remain F. I...

Is it possible to highlight a specific column in an excel chart using VBA? Here is the data listed below the bar chart: Sep-18 Oct-18 Nov-18 Dec-18 YTD 4.2% 4.5% 4.4% 4.3% 4.4% I only want to highlight the YTD column in gray. Thank you

I would like to add more data to my excel chart not directly related to the chart itself. Am I able to achieve this without using the snipping tool? Any help would be greatly appreciated. Thank you

Hi, I have 3 columns whose cells are populated based on formula and vlookup. Due to vlookup, number of rows returning data can vary.(sometime it can be 5 rows and other time it can be 10 rows) Now When I am creating 2-D Bar chart(giving it range of 10 rows per column), with values of 1st...

I am trying to create an excel chart that will show me my inventory every week for each week of the year so that I can see the trend. I have a chart that I track the numbers daily and then on a different tab I have a chart that does a vlookup to get each Sunday's dates. I have the vlookup set to...

Hi, can anyone please recommend any good Charts for displaying the frequency of combinations ? So for example if I had 10products, that's 1e+10 combinations, is there some sort of heat map chart or area chart that would display the number of the combinations ? Thanks in advance for your help...

Hi there I have a template tab with charts linked to data within that tab, the data is dynamic to a single cell within the tab and this cell is linked to the tab name. I have copied the whole sheet to over 200 sheets each with their own dynamic tab name. However I have now just realized that...

Hi, I'm trying to make a X Y Scatter chart a little more useful. Essentially, I've created something like a "Gartner Magic Quadrant" chart. Easy enough to plot the points based on the X and Y axis values. But, I want to vary the diameter of the plotted points (the dots) based on another...

Hi! I have created a graph which compares three measures. As I let the users choose the measures, the third measure can be either numbers or percentages. I used conditional formatting to adopt correct formatting. When I created a chart from this and linked the third measure to secondary axis...

Hello there, I request your help on solving this question. Say, I have values such as 1,2,3,4,5,6,7,8,9,10 plotted in Excel Chart. If I want to delete values 3,4, the missing values can be interpolated using the "Hidden and Empty Cells" option. This option connects only through a thick line...

In excel chart a range name that gets its value from a formula but does not refer to a cell reference is not accepted as Series Name. e.g. sheet1!var1 =IF(Sheet1!$A$2="V1","Vendor1","Vendor2") is not accepted as series name, output is just text value not a cell ref. sheet1!var1...

Hello, I'm admittedly not an expert when it comes to excel charts. What I have here is a small data set comparing average fees per account for four different mutual funds. I have that charted off to the right, but in the data table below, I just want to show the % change. I'm just trying to...