chart 2013

Need to create a basic line chart showing $ amount on Y-axis and dates on X-axis. No issues on the $ amount, but cannot figure it out how to make the dates to work. The main issue is that my starting date is 3/24/15, and the following dates should be the end of the following quarters (6/30/14...

I have a chart that shows monthly revenue going back multiple years. I want each months bar on the chart to be the same color, no matter what year. So January will always be front blue and October always pumpkin orange, etc... Besides going in and changing each color by hand (which is a huge...

Hello guys, I have searched the forum but i cannot find something similar to my actual problem. I tried to make a classic speedometer with doughnut and pie chart and it does not work properly (ex. my value is 80 and the needle is somewhere else totally) I use excel 2013. The speedometer...

Hello)) I am trying to conditionally format my chart. I know that I can do it with "IF" statement (which I do successfully). But I want to format the fill color of my chart bars based on the cells' color (bars take the same color as cells). Something tells me that there should be an easy VBA...

Hi All I'm hoping you may be able to help with an issue I'm experiencing when trying to create a multi-level doughnut chart using Excel 2013. It's a work project and I've modified an existing file that contains all of the income and expenditure during a month. It tracks a variety of data...

Hello, This may be very simple, I just can't figure it out. I need to chart some date & time info, it's 4 different things(times) per date. I can find a chart but have trouble changing the data field to my values or I change the values but don't like the chart. I am using the Office...

Dear all, I am kindly soliciting your help for a project I am currently working on. I would like to show the distribution of several quantities towards different postal codes in a country. In my data I have the postal code and each of them with a subsequent quantity. I want to see in which...

Sub Print3() Dim sht As Worksheet Dim CurrentSheet As Worksheet Dim cht As ChartObject Application.ScreenUpdating = False Application.EnableEvents = False Set CurrentSheet = ActiveSheet For Each sht In ActiveWorkbook.Worksheets If .Name <> "CHART OVERALL" Or "CHART TL" Or "CHART...

I am trying to make a chart that will change based on the active cell's row. This workbook will be used exclusively on iPads for field work. As far as I know the ios version of excel does not support macros so I will have to make this chart without using macros. I've figured out how to do it...

I'm sorry if this is an easy question but I can't figure it out....and even if it is possible. I've got a sheet that has about 1400 rows of data that has a 2 columns - Date/Time and Surface Temp. In one given hour there may be a dozen records. I've got another sheet that has 2 column names...