Hello! I have a chart with 4 axes (i.e. horizontal primary, horizontal secondary, vertical primary and vertical secondary).
I'm using Excel 2016 and need to switch the horizontal secondary axis at the top (date) with the horizontal primary axis at the bottom (number). Unfortunately, I...
Hi all -
I've been working on creating a simple macro that changes the formatting of the horizontal axis on 9 charts. We have an internal software that refreshes dates always using one format and we want to present those dates in a different format for presentation purposes. What I want to...
Hi I'm a bit confused on this one...
In Excel 2007, I am using a trendline on a "Line with Markers" chart. I have Date on the X-axis and Weight on the Y-axis.
I'd like to do a 1-year projection from the last date where there's a Weight value plotted on the chart.
For example, if I have...
I have been trying for hours to create an X-Y scatter plot with horizontal labels.
Below is my data (column A- Horizontal axis and column B- verticle axis). When I try to create XY scatter plot in Excel 2010, horizontal (category) axis labels option is greyed out (disabled?). Exact serial nos...
Hi There,
Maybe I am missing something, but I believe the only chart type that gives the flexibility to display all the data you want (when working with date & time values as the x-axis) is the xy scatter.
In this, I can set the increments to whatever I want (1 min, 1 hr, 1 day, etc...) and...
Hi,
I am creating a simple spreasheet for a medication dosing regime. The problem I am having with the horizontal axis labels are best explained in screenshots, but I cannot post those. Therefore the links
Click here for the data I need to display as 2 charts.
Click here for the display as...
Hi There. I have 19760 date & time values in column A (it starts in June and each row is incremented by 1 minute). Columns B, C, D, and E have energy uses for each minute for different pieces of equipment. I want to create a stacked bar chart showing the total energy used for each minute but in...
Hi There. Is Excel capable of creating a horizontal graph whose major ticks are the first of each month and also plot two series of data whose dates do not align with each other? For example, I am creating a 2D Line Chart with markers and formatting the horizontal axis to start at the beginning...
Hi There. I format my cells to the custom format of dd/mm/yyyy hh:mm:ss to use for a chart. It displays the chart correctly for XY Scatter but this type also doesn't recognize it directly as dates (it converts it to numbers which can then be transferred to dates). When I change the chart type to...
Okay, so I have a bar chart I've created whose data source is a range of cells (Progress!$L$4:$Q$6). The category labels (horizontal axis) of the chart USED to reflect the category names as text values (nameA, nameB, nameC, nameD, and nameE), which is what they were supposed to do. I should...
My double axis chart is tracking $ values on the left and count on the right. Dates are on the horizontal axis, with the oldest date to the right. The count is charted correctly; i.e. the dates correspond to the count. But the $ amounts are charting backwards. In other words, the $ amounts...
In Excel2007, I have found that some of the data tables in new charts are combined with the labels on the primary (lower) horizontal axis. On others, there are both labels on the axis and on the data table. How can I consistently create graphs where the axis labels are shared with the data...
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 MrExcel.com.
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 "mrexcel.com".
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.