1. S

    Align zero on secondary axis with primary

    Hi, I am running a macro to create some charts, my orange line is on the primary axis with the blue and purple are on the secondary. I need the secondary zero point to start at the same as the primary, is there a change to my VBA code that would do this?? Also... how do i change the colour of...
  2. N

    Change Y axis in clustered column chart, from values to text

    I have a clustered column chart, with values ranging from 0-10. And I am currently showing integer values in the y axis, but I wish to show rankings rather than values. so for 0-2.5, D, from >2.5 and<=5, C, from >5 and <=7.5, B, and >7.5 A. I would like to show these rankings in the y axis...
  3. D

    Charting Data

    I am trying to take data with random dates 9/5, 9/12, 9/19, 9/26 on the X axis and graph them and when I do the axis with the dates is reading all dates in between is there a way to only have the dates specified show up on the graph rather then all dates in between?
  4. T

    Excel 2010 Charts Question

    Hi, I a trying to create a 2-d column chart that has a secondary axis on the right hand side to show percentages using the data below Sales Success Rate Pre Launch 20000 15% Post Launch 30000 20% I want to see...
  5. B

    Dynamic date range on x axis

    I am struggling to create an x axis which covers a date range that changes. The attached image shows my data, the bar graph and the date range I want to use on the x axis.
  6. P

    Auto-Range and Scaling of Chart Axes

    I have two charts taking data from large ranges. Because there's no way for me to know what each user will face in their individual circumstance, I can't reliably set the Y-axis minimum or maximum to a fixed value. I want the charts to automatically determine the Y-axis as the users input their...
  7. L

    Excel: Dynamic plot with specific variable on x-axis

    I have a variable Y Y = RANDBETWEEN(2,15) And a variable X X = NOW() I am using the following VBA code to refresh the date; to simulate a real time data flow: Sub Calculate_range() Range("A1:A7").Calculate Application.OnTime DateAdd("s", 2, Now), "Calculate_range"...
  8. I

    make chart axis labels hyperlink to other pages

    I have an Excel bar chart I would like to make the chart axis labels hyperlink to other other charts that contain additional details about the specific tag of interest. Is this possible?
  9. Johnny C

    XL2016 When I delete a series that series stays and the rest disappear?

    Different issue to the previous one but vaguely related. I have charts set up in XL2013 32 bit, I've now got XL2016 64 bit with secondary axis. When I select a series and click (or press) delete, that series stays but all the others disappear. Doesn't matter which axis they are on. When I...
  10. Johnny C

    Chart series disappear in XL2016 when secondary axis changed

    Help! I've got a large model with 30+ charts. They were created in XL2013 32bit, I've now got 2016 64bit. When I try and amend the bounds (upper or lower) for the secondary axes, all the chart elements (series, axes, legend) disappear and I get left with a blank chart. I tried deleting the...
  11. D

    I am trying to match the exchanged rate based on the date of the sales data and convert the currency to GBP, Then make a pivot table to show sales fro

    Attached is a set of sales data. The task is to produce a graph showing the total paid orders in GBP, with the months across the horizontal axis and sales volume (including postage) on the vertical axis. The graph should aim to compare year on year performance and I need a slicer to be able to...
  12. C

    Bar graph with two different scalas on the Y-axis

    I have a table with two data columns: the first column contains naming values, the second column contains values from 0 to 1, the third - values from 1.000 to 100.000. I want to display them on the same (bar) graph. I've seen such graphs, where on the X axis are naming values (from column A)...
  13. C

    Gradient Y Axis

    Hello, I'm wondering if there is a weigh to "weight" my y axis on an excel chart. I have many points that fall in between $0 and $1,000,000, fewer that fall between $1,000,001 and $10,000,000 and very few greater than $10,000,000. So, I would like the points that fall in between $0 and...
  14. S

    Bring axis to front on excel chart

    Hi. I've got a chart with several thousand data points (all of which must be plotted). The problem is that the data with a zero value (for either the x or y axis) are being displayed in front of the axis line, whereas I would like it the other way round. Is there some way I can select the axis...
  15. C

    Moving Axis Cross Points automatically within Excel 2010

    Hi everyone, I am hoping that somebody will be able to help me as I haven't been able to figure this out on my own or find the answer anywhere on the net yet. I am in the process of creating a data dashboard for data reporting at work. As part of this I have created a document that allows...
  16. I

    Clustered bar chart

    I have clustered bar chart. I have one array of values where the values can go from -5 to 5. The y-axis is a 0 which is good but the y-axis labels are also in the 0 range.Since the axis value is positive or negative, some bars actually overwrite that y-axis labels. If I move the axis to one...
  17. JackDanIce

    Add vertical line to chart

    Hi, I have a graph based on a 3-column data table where x- axis is time (months, Jun 2019 to Dec 2020) Primary y-axis is account balance ($0 to $3.5m) Secondary y-axis is PnL (-$300k to $200k) August 2020 is first month PnL > $0 (Aug 2020 as the answer is calculated in a different cell) How...
  18. V

    MACRO to build a graph - y axis not shown

    Hi all I managed to create a macro to build a graph which updates each time the lenght of the columns change. When I try to put the name of the horizontal axis, it work. When I try to do the same with the vertical axis it doesn't. Anyone willing to help? I am very grateful Thanks a lot valentina
  19. G

    Advanced Graph options.

    Hi, I'd like to be able to plot multiple data series on the same graph with the same horizontal axis. I have sets of data including metrics like temperature, pressure, distance, height, speed etc etc all of which have the same horizontal axis (time). The problem is that all of the metrics...
  20. S

    Charting Trouble

    So I don't know how to set up a chart properly. Column A is Time in 10ths of seconds. Column B is the data at each tenth of a second. I want the time in seconds (1 through 80) on the X axis. And Column B is the line with data ranging from 0 to 1700. I can't get the time in the X axis. I get row...

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