chart axis formatting

Hello all! I have some charts that I am populating from pivot tables. The data I am working with is sorted by fiscal year (FY) on the X, or horizontal axis. I see that excel lists the months chronologically, however (Jan-Dec from left to right), however I need the months on the chart to...

Hello, I'm having a bit of trouble achieving two things with my excel chart. This is the chart: I want to set some cells in the worksheet so that I can enter the minimum and maximum bounds of the X and Y axis for the chart, without having to go to the format plot area options. I have found...

I know this has been asked before, but I have tried every fix I have found on this board and microsofts, and none of them have worked. Using Microsoft Office 365 ProPlus. Just need a chart that shows temperature and humidity vs date/time. My data set is pretty small, only 20,000 lines over a...

I have a dashboard in a workbook that displays a number of charts that have their data stored in a different workbook. This is so that we can update the data upon demand and independently of the dashboard (as it may have a number of concurrent viewers). It works pretty well on the whole, but...

We have time and date data from our ordering system, we want to be able to see the trends in which day of the week/time of day are the most common for orders being placed. This is what our data looks like (copied out of excel, formatting in excel is two columns, Name and Created date, date and...

I'm tracking the daily productivity for over 300 employees and 250 working days. Currently, the date/working day is the Legend Entry (Series) and the employee name is the Horizontal (Category) Axis Label. I need a way to switch them around so that the date/working day will be the Horizontal...

Hello this is my first time post so please bear with me if i did not clearly stated my problem. My question is regarding charting in excel where i have main category(SW rel) and sub category(Problem type seen in given sw release) that could have 3 different features where problem can be seen...

I have data which I want to display on an Excel column chart. It represents the number of sales per week, where the date is the first day of the week: If I leave the dates as dates then Excel interprets this as data for one day out of seven, so I get thin columns with large gaps...

<tbody> a 2 b 4 c 6 </tbody> I want to plot a line chart with the first col being the x axis and the second col being the y axis. However, i also want the color of each point on the axis to be as in the table. How can i change the default which is black? I know we can change the...

Hello, I have a chart with three variables plotted on a chart with two y-axis. Two variables are tied to the primary y axis, and the third is linked to the secondary y-axis. When the chart is displayed, the third, secondary axis variable shows up in between the two other variables. Is there...

I have a table that details what information is being delivered each month which I have pulled into a chart as part of the x axis. Is there anyway to reflect the information being pulled into the axis based on the formatting of the text in the table?