excel chart

  1. 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...
  2. 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
  3. 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
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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:
  14. 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...
  15. R

    Use VBA to create Excel chart

    We need a program that uses VBA to enter data into an Excel sheet and then displays a line chart. Office version is 2013. I found a number of examples on the Internet, but could not get any of them to work properly. This may be due in part to differences in the many versions of Excel. The...
  16. D

    Help required to draw XlLine chart in excel

    Hi Experts, I need your help to draw xline chart in Excel.I am not proffessional expert eiether in excel or Vb .I am a doctor(told you to understand my knowledge on these VB or Excel) I want to draw Xline chart with X-axis having dates Other 2 variables are Nifty closing price (which...
  17. N

    Chart data through formulas

    Quick lay out... I have a chart with multiple columns, up to Z and over 4000 rows. The rows contain dates from 2003-future. I have another page that draws data from this page by users selecting information from drop down menus. From the information they select in the drop down menu I want a...
  18. T

    Excel Scatter Chart - X Axis Tick Marker Values

    Dear Excel gurus, I really need some help with Excel xy scatter charts. I need to edit the X Axis values/scale to reflect ONLY values that are charted, instead of a generic range. For example... I have a scatter chart tied to an Excel worksheet, with a data source that contains 4 Series. The...
  19. A

    Sphrical Drawing in Excel

    Dear all. I have attached Excel sheet above. I wanted Draw Graph as show in figure.I wanted to plot grapgh for Zenith, azimuth, elevation W.r.t Time Of day. (http://en.wikipedia.org/wiki/Horizon...rdinate_system http://en.wikipedia.org/wiki/Spheric...rdinate_system) <tbody>...
  20. E

    Need some guidance to understand and create this kind of chart

    I have come across a very interesting chart from Office Templates, however it seems too complex for me. All the data and working is there, it would be great if somebody would help me understand it, here is how the chart looks: The chart is made for Excel 2013, which I am also using. The...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

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