axis

Hello, I have an issue which I have not found a solution for. I have a chart that links the axis titles to a cell in worksheet tab (=Data!$A$6). I also need to reset the axis title for alignment (long issue). The code I have is Dim Axs As Long Dim AxSide As Long Dim Tstring As String...

Hi experts I am trying to plot a nested x axis in a stacked or your standard column chart in Power BI and it's turning into a nightmare... I have Turn on responsive under "General" formatting and Turn off "Concatenate labels" under X-Axis.. cannot see the wood for the trees....sample data...

Let say I would like the first three tic 5 units aoart and the next 3 10 units apart. Is this possibly done ? Really appreciate the help.

I have a simple three column sheet where the rows represent dates. The dates are not in perfect calendar intervals (12/31/15, 12/30/16, 12/29/17) but when I create a graph the axis displays the dates as 12/01/15, 12/01/16, 12/01/17. I have tried setting the axis type to "Text axis" but that...

Good day, I am attempting to chart weekly data in the form of a bar chart. My data is in Power Pivot. I am using a Date Table linked to my Fact table on a field called DateInt which is a column of each day of the year formatted as an integer. The other column, WeekBeginning, is the beginning...

i have a combo chart and i want the slicer to control the values on secondary axis how? thanks

I have a line chart with Dates on the X Axis (Jan 1-Dec 31)...and Hours on the Y Axis (0-12). I would just like to add a horizontal line (Series?) at 8 hours. Thanks, Jim

Hello Mr. Excel Masters! I create a chart to visualize "Key Events for a Project" based in a XY (Scatter) Chart. There is a way that Horizontal Axis reflect the dates entered for the chart? I mean, Each milestone date show on the axis instead of a range of time? Link to Template download...

I currently have several charts that show the Top 5-10 items in a list. Currently, the chart sorts it by lowest to highest. In trying to figure out how to have it sort from highest to lowest, I located the "Categories in Reverse Order" option within the Axis formatting, however when I click...

Jon Peltier makes a masterful presentation for ALL things related to excel charts. Thank you! Most recently I have followed his diversified methods of adding horizontal lines for average or n-sigma ranges. I am using excel 2016. After I get to the paste special step, I can see the series has...

Is it possible to create line chart in excel with all dates included in axis X even if my data does not have any value for particular day?

Hi All! I have two drop down menus consisting of dates using the Data Validation method. I'm trying to get the X axis to update based off of the input from those drop down menus. For example, if the user selects 11/1/17 and 12/1/17 the graph should update on the x-axis to reflect that range...

Hi I want to draw a chart for the table below. I have 2 charts in one. I created 2 charts with different Axis (one is secondary). So far so good. Then I wanted to delete the axis and right click on each chart and then click on "Add data labels". After adding Data Labels, I thought I do not need...

I have one chart on a worksheet and I want to use VBA to adjust the values of the Series which are in the chart. There are four series shown in the Source Data info box for the chart. In addition there is a Category X axis label shown which has values also. I know that I can use, for...

Hi, I have no idea if you can do this in excel or not. I can't attach the spreadsheet or paste the image I wanted because it is hard to explain but here goes. I want a bar chart that on the vertical axis say test1, test2, test3. The horizontal axis have 1 to 12. So it will have a bar for...

I am on Excel on Mackbook 2011. I know there is an option on microsoft excel on the graphs to position the axis on the ticks marks instead of in between. On Mac I can't seem to find this option and my X axis is in between when I need it to be on the tick marks. Can anyone help me out? Is this...

I have three instruments that have their values recorded every 5 minutes This produces the following sample data pulled from a SQL database: Time Name Value 17/04/2018 00:01:02 Instrument_1 1.49 17/04/2018 00:01:25 Instrument_2 0.35 17/04/2018 00:01:53 Instrument_3 11.39 17/04/2018 00:06:02...

Hi all, Firstly, I'll start by saying i'm a complete graph novice so this might be really simple but I've tried reading through loads of posts and just cant seem to find the answer. I'd like to design a stacked graph (where only 1 data point on the horizontal axis has any positive values) and...

Good morning Everyone, I'm hoping someone might know the solution to fixing this problem. I've created a Chart with only 2 Series. When they're both on the same axis it looks fine as any graph does, however i want to move one Series to the secondary axis. When i do this, the Bars in the graph...

I use the below code to automatically adjust my axis on all my charts to the maximum and minimum on the chart when c2 changes and it works great but it only works on the primary axis. Is there any way to change it so it works on both the primary and secondary axis. Thanks Sub...