axis

I am using excel 2016 for mac, and am trying to use the "horizontal (category) axis labels. in charts" But I can't seem to enter any thing into the box for this. Ultimately I want to be able to put data labels that are not the numeric x and y axis values, but cannot find a way to do that...

Hello, I have a spreadsheet contains several tables and column charts. Tables link t other worksheets by excel formulas. I have been using this file for a couple of month ad it used to work perfect. Since I have Several tables and charts, It is hard an crowded to make a presentation with the...

I have a chart with the horizontal axis rotated 270 degrees. I need to have the chart adjust as I make changes via VBA. This is what is recorded, but I don't know the exact height. How can this be modified to allow the horizontal axis is be completely visible and not scrunched up? Sub...

Good afternoon I have a workbook with four tabs, three of the tabs contain charts. I would like help to be able to automatically update the minimum and maximum on the axis as the data changes. All the charts start at 0 and it would make more sense for the minimum to start at a value closer to...

I have a table which has data I need for my spreadsheet. The table has two rows of headings on both X and Y axis. Is there a formula that will allow me to get data from this table?

I am trying to figure out how to build a schedule chart with the dates on the vertical axis and times on the horizontal axis, and then use error bars for horizontal duration... The dates ae irregular and the on t horizontal axis is from 6 AM to 6 PM. I have worked with some charts I found on...

Is it possible to create a chart like this in Excel? I was thinking making a bunch of individual charts and overlaying them with transparency and resizing them so they match up might work. But if there is a better way I would appreciate some assistance please. You see it is based on date across...

Hello, I need to clean this chart up so it only shows each month/year on the horizontal axis one time. The data range I am using as the horizontal axis labels is W14:DUR14. Each cell in this row has the Month/Year in sequential order, but lots of duplicates. The line data in the chart is on row...

So I have the actual Regression table however I can’t fogure out the formula for the x y axis. Can you help?

I have a line chart on excel 2016, I have data listed vertically in columns A-B-C-D. The chart is displaying all three lines fro B-C-D. The D line is data in percentage % format which appears on the right side Y axis. I want the data from column B to be displayed in the right Y axis but still...

I have an area that pulls in either an absolute or percentage value using adrop down box. I have set up my chart to use this area for my chart. However, the Y axis remains as a percentage when an absolute is chossen. How can I get the chart to change between absolute and percentage?

Hi all, I'm trying to create two graphs. One is a column graph. The other is an x y scatter. But I have the same problem for both. I need to remove the first and the last tick marks on the x axis and their labels. Note that the tick marks must be located outside the axis (not inside). I'm not...

I am trying to do a graph in Excel 2013 that uses custom dates that skips weekends along the Y axis. What I am currently using is =C26+IF(WEEKDAY(C26)=6,3,1) where C26 is the previous date and I have a list of ten dates using this. The only way that I have currently found to attach these dates...

Hello, I thought this would be simple to do but I am stumped by it so hoping someone can help me. I have a line chart with months on the x axis and the quantities on the y axis. All I want to do is have months on the Y axis and quantities of the x axis but just can't work out how. If Itry...

I need to create a graph just like the one shown in the picture i attached. it does not need to have the curve, rectangular bars would be fine. but the axis should be the same. I cant figure out how to make it in excel. If someone can explain, it will be helpful. Thanks (link to sample data in...

I have a Membership tracker in excel where member can log in and excel logs their names (Column A), Daily Fee (Column B), Time in & Time out (Column C&D), and then totals for Hourly Total, & Fees Owed. I want to create some kind of to illustrate when people are coming and going. I am having a...

Can you make a cluster column chart with one series data charted on a secondary axis? For instance, I'd like to show x,000 new customers new customers by month with revenues of $YYY,000 for new customers by month. The issue is, the revenue would need to be plotted on a different axis because...

Hi all. Using Excel 2016. I plotted values and added category labels for Quarter >> Month >> Day of Week so I have a Multi-Level Category Label. For some reason, Excel is adding 2 additional lines as the right-side of the category axis. All other dividers on the category axis are correct. Have...

I have a question. I have a bar graph of Years and Months. How do i get the graph to show the months Grouped by the same color? Example: I want January 2015, 2016, 2017, 2018 to get all the same color, but every month to have it's own color. Ideas? Right now Month and Year are in the AXIS and I...

Hello, Does anyone know how to have the axis of the graph be a table? The example of the table is below. I would want a line/bar graph to use the months as the axis and the color of the Monthly Actuals and Monthly Budget to be the same as what is used in the graph. <tbody> Oct November...