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