excel chart

  1. M

    Excel charts - excluding columns with NA values

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

    Excel Chart - number formatting as decimal only if decimal values are available in source data

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

    In MS word, paste multiple excel charts, make them embeded but keep only one copy of source data.

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

    Chart Data table content need deletion

    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%
  5. M

    Update multiple chart series & multiple chart with VBA

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

    Put multiple data series on same graph with vba

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

    Single Custom X-Axis Label (Date) in Excel Chart

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

    VBA highlight specific column in an excel chart

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

    Excel Chart - additional data

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

    #N/A displaying in Bar Chart

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

    Excel Chart for week 1 - 52

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

    Excel Charts for Combinations

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

    Chart series link to tab name

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

    3 and 4 Dimensional Chart

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

    Dynamic chart axis format (Numbers and Percentages)

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

    Blank/NA values to be shown as dotted line rather than straight line in Charts

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

    Series Name Excel Chart - Is cell reference necessary?

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

    Excel Charts: Customize Data Table

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

    hide 0 values in excel chart

    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:
  20. C

    Stacked Cluster Column: Turn negative values red

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back