excel chart

hello. i need help on hiding the 0 values in excel chart. ive found things like "#" in format code but it rounded up my figures. i have data like 1.7 or 6.5 and it rounded up. is there a way to hide 0s in the series without changing the other figures in the series? :( :confused:

Hi All, In short: I am wondering if there is a reasonably quick way I can make the negative values (with the dashed borders) RED so they stand out more. It seems like I can either change all of them or none of them. I think I can also go in and manually change each one. The problem is that...

We need a program that uses VBA to enter data into an Excel sheet and then displays a line chart. Office version is 2013. I found a number of examples on the Internet, but could not get any of them to work properly. This may be due in part to differences in the many versions of Excel. The...

Hi Experts, I need your help to draw xline chart in Excel.I am not proffessional expert eiether in excel or Vb .I am a doctor(told you to understand my knowledge on these VB or Excel) I want to draw Xline chart with X-axis having dates Other 2 variables are Nifty closing price (which...

Quick lay out... I have a chart with multiple columns, up to Z and over 4000 rows. The rows contain dates from 2003-future. I have another page that draws data from this page by users selecting information from drop down menus. From the information they select in the drop down menu I want a...

Dear Excel gurus, I really need some help with Excel xy scatter charts. I need to edit the X Axis values/scale to reflect ONLY values that are charted, instead of a generic range. For example... I have a scatter chart tied to an Excel worksheet, with a data source that contains 4 Series. The...

Dear all. I have attached Excel sheet above. I wanted Draw Graph as show in figure.I wanted to plot grapgh for Zenith, azimuth, elevation W.r.t Time Of day. (http://en.wikipedia.org/wiki/Horizon...rdinate_system http://en.wikipedia.org/wiki/Spheric...rdinate_system) <tbody>...

I have come across a very interesting chart from Office Templates, however it seems too complex for me. All the data and working is there, it would be great if somebody would help me understand it, here is how the chart looks: The chart is made for Excel 2013, which I am also using. The...

Hi, I have a basic piece of vba which changes the type of chart from a line chart to a column chart: Sub COLUMN_CHART() ' ActiveChart.ChartArea.Select ActiveChart.ChartType = xlColumnClustered End Sub The problem i am having is that if this is pressed its works fine. But, if i...

Hello, I have a chart that have y-axis values normally between 0-50 but sometimes i get a peak with value 400 and then my chart becomes unclear because y-axis max value then goes up to 400. Is it possible to set a roof here so max value on y-axis is e.g. 60 and values above that is visible as...

Hi, What is the way of changing chart defaults (other than making new templates), especially the chart size, 'legend' font size, 'axis items' and 'axis title' font size, 'chart title' font size? The change can apply to all the chart types in excel. Eg. 1. The legend size is set to 10 by...

I have a table setup that drives my pivot table. My pivot table then drives my chart. I have identical conditional formatting applied to both the table and the pivot table, but need VBA to assign the same conditional formatting to the chart. The chart will change month by month so the values...

Dear Experts, I am designing a VBA application for finance. It extracts data from the web and calculates certain index based on the information. I found a way to create a dynamic macro based chart in excel worksheet which incorporates new information but I want it to appear in user form...

I need to plot some laboratory data to determine the upper and lower warning and control limits for a particular analysis method. I have already have one graph set up for the low quality control (QC) sample, however, when I use the same chart to plot the high QC sample results the y-axis scale...

I need to find all chart objects that use a particular range as a value for a sequence so that I can update them to use a different range instead. The following is the code I already have Option Explicit Sub testUpdateCharts() updateCharts Range("A1:A10"), Range("B1:B10") End Sub Sub...

I use Excel to draw charts, copy them into Paint Shop Pro (& from there import them into Word). I have one quite large chart and when I try to "paste as new image" I get a dialog box saying "Unable to get data from clipboard". Any suggestions?:confused: