format axis

Hi, I'm trying to recreate a Y-Axis format that I saw on a paper and I'm not sure how to do it (or if it can be done in Excel). As you can see in the picture, the axis starts at 0 but there's an // that indicates a cutoff (marked with a red arrow). Then, the value restarts at 3000 and goes up...

I am trying to figure out if I can have a specific axis option (vertical axis) where my major unit is a whole number, so 1.0 but I still want it to Auto in case a large number comes in where it has to skip numbers to increase. I hope this makes sense. Thanks all!

Hi all, I am trying to create a workbook that plots a line chart of two data sets. the problem i am running into is that some of the time-stamps from one set will not match up with the others, and thus need to be ignored. i managed to do this with if statements easily, and currently, any non...

The y-axis of my graph is a combination of text and numbers: (bar) (bar) (bar) 1412 1501 1502 15Q3 Margin: (3.5%) Each row of the above set of data is contained in seperate columns in source data. I like the display of the data on the graph axis in this manner, however, I cannot seem to get...

Hi, When I refresh a Pivot Table trough VBA, the horizontal axis date format changes. It has to be dd/mm/yyyy, but automatically changes to U.S. date format mm/dd/yyyy. If I refresh the table manually in excel works fine and the format doesn't change. I've searched trough this forum, google...

Hey there, Regular lurker, first time poster. :eeek: In Excel 2007, I need a chart's vertical axis to change based on the reference cell format changing. Basically, I have a "dashboard" that will allow a user to select whether they want to view units or dollars in a table. The table that the...

As I add more data to my scatter chart, I'd like it to just show the most recent 10 data points. I have date on the x-axis and I would like the chart to only show data for the 10 most recent days.