axis

I need to add two horizontal lines at 60% and 90% to a bar graph. I also need to change the text color for one of the items in the Y axis. They are survey responses and the text of the word is in the Y axis. I need to differentiate one of them that is reverse coded by font color or italics. I...

Hi, I am wondering if it's possible to change the axis labels of my date range from MMM-YY to the date of 01-MMM-YY ? This is because I have gridlines and as an example one of my bars starts on the 1st July 2019 but my bar will start before the gridline of "Jul-19" because the axis date is...

I have a graph that I want to go from 0 to 80000 in 10000 unit increments on my x axis. I want my data to fall not on the major tick marks (ie: a 25000, 45000, etc). How do I set this up?

Hi guys This issue at first seemed really simple but I have been at this for hours and cannot make any progress. I have search a ton of articles, boards and all the solutions posed do not fix the issue i am facing, which is to place the secondary Y axis (which is a calculated field, showing...

Hi Internet People I have the following Problem: The Time Axis of my Diagram only shows Zero-Values. The Values for the time axis are generated by a formula that puts there an empty string when the value in the raw data sheet is missing. Exactly that empty string makes then problems for...

I've got a basic star schema data model in Power BI. In my Dates table I have "the usual" columns for date, year, month (name + number) and ISOWeek. I've created the date hierarchy that I want to display my data in but I can't get the date axis to work as I'd want it to work: What I'm after...

Good Afternoon All, I'm trying to put together a spreadsheet matrix with a "item name" on the Y axis and "Gift Name" on the X axis. Each gift comprises a number of items within one gift. Both axis information is held within 2 separate worksheets within a source file workbook. I have used...

Hi All, I'm try to do what's set out in this post, https://www.mrexcel.com/forum/excel-questions/450643-chart-types-2-axis.html#post2225665 EXCEPT I want to set a different minimum value for the two datasets I'm graphing...when I set minimum axis value to 0 on the left axis and to 1,000 on...

Hello everybody. I've the following table: https://imgur.com/D8BG8cM I need to represent these data in a line chart this way: - on horizontal axis, YEAR - on vertical axis, ALPHA and BETA (in order to compare them on a timeline). How can I set the axes?

Hello All, I hope you can help me. I have a graph, and I have dates as the axis labels (horizontal axis) - I am struggling to find a way to add more axis labels (more dates) along the horizontal axis. Do you have any advice on how to do this? Do you have any further tips to format the graph I...

Using Excel 365, I am constructing vertical timelines by making scatter charts, following this method: https://www.vertex42.com/ExcelTemplates/vertical-timeline.html In that url, the first illustration shows the desired output; second one shows the simple data table. I am not using a...

Is there a way to automatically update axis bounds when new data is added to the chart? Thank you. David

Hi, I'm looking for some help please. I need to find a way of including a value that is being displayed as a duration (e.g. 12:32 as mm:ss) but is inserted into excel using the decimal number system (as it allows me to add different times together). Generally these values that I am working...

Hi everyone, I want to make a pivot chart to track performance of drivers in a race series. I can make it as a normal chart, but would like the have the filter options to remove certain drivers, or compare directly. I'm unsure on how to layout the data source, and seem to be having issues...

Hi, I have an interesting case with line charts. There are 4 tables and 4 line charts in linked file. 2 of the charts show 0 point on x axis and the other 2 dont. I can set the maximum amount of x axis to be zero, but it will not work if numbers are positive. I know there is a logic behind...

I am having trouble with the X Axis being formatted differently in two different charts using the same source data. In the first chart, the X Axis presents exactly as it is formatted in the source data: 2010, 2011, 2012, etc. In the second chart, the X Axis, while referencing the same...

When I change parameters for a graph (for example, axis limits), Excel wants to redraw the graph after every change, which can take a long time. I want to complete the editing of parameters (for example, both axis limits, axis units, whatever) before redrawing the graph so that I don't have to...

Hi In my Pivot chrat I have a axis field button that filter the values taken by pivot chart. How can I connect this value filter with a combobox at userform ? I want to show pivot chart at userform with image control. Thanks alot.

<tbody> A B C 1 Item1 -2 Station25 2 Item2 -5 Station26 3 Item3 -7 Station27 4 Item1 -8 Station28 5 Item3 -10 Station29 </tbody> Hello, I need help please. I have been searching the internet and cannot find this solution. Column B is plotted on a chart as...

Hi all, Excel 2007 I have created a macro to create charts. This macro decide creation of 3D or 2D charts based on parameters selected for X and Y axis. If parameters for both axis are selected is gives 3D chart. If parameter of single axis selected giving 2D charts. Every time it deletes the...