excel chart

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...

hello. i need help on hiding the 0 values in excel chart. ive found things like "#" in format code but it rounded up my figures. i have data like 1.7 or 6.5 and it rounded up. is there a way to hide 0s in the series without changing the other figures in the series? :( :confused:

Hi All, In short: I am wondering if there is a reasonably quick way I can make the negative values (with the dashed borders) RED so they stand out more. It seems like I can either change all of them or none of them. I think I can also go in and manually change each one. The problem is that...