Plot/Chart Tick/Check Marks

Apr 21, 2008

Is there any way in which I can map the tick mark labels on either the x-axis or the y-axis to different values other than the ones that are being plotted for.

For example, lets say the data is:

1 5
2 6
3 10
4 15
5 8

I want to plot these in a chart but instead of displaying 1,2,3,4,5 on the x-axis, I want to display a different column, say,

5
7
9
11
13

The answer is not as simple as plotting the required x-values with the y-values. I have just used a simplistic example but the thing I am trying to do has dependencies involved so I cannot simply plot the chart with the required column.

View 5 Replies


ADVERTISEMENT

Getting Rid Of Tick Marks

Nov 28, 2008

Some sent me a large spreadsheet with random rows throughout the spreadsheet highlighted in diffierent colors. I have a module that will sort the spread sheet by Color - however it doesn't work on this spreadsheet because - for whatever reason - every cell starts with a tick mark.

I tried to do a replace all - and excel just told me I was crazy.

I even tried going through and manually removing the tick marks - still no luck.

If I export the sheet in to txt and then re-import it I will loose all the highlights...

View 9 Replies View Related

Adjust Interval Between Tick Marks In Graph

Feb 6, 2014

It is impossible to adjust the interval between tick marks when displaying an horizontal axis with 2 categories (years and weeks). The following steps do not change the space between the tick marks.

-Select the graph;
-Chart Tools - Lay Out;
-Current selection - Horizontal (Category) Axis;
-Format selection;
-Axis options;
-Interval between tick marks: 4.

How can I change the interval for the tick marks to display a mark after every four weeks? Is this a bug or by design?

View 5 Replies View Related

Check / Tick All Rows With Same Data

Mar 21, 2013

So let's say I have a table like this:

Apple
Banana
Cherry
Banana
Durian

And when I tick one row:

Apple
Banana
Cherry
Banana

Durian

The rest of rows of same values will also be ticked:

Apple
Banana

Cherry
Banana

Durian

I would like to have the macro/VBA for this.

This question was also posted at:

ExcelForum: [URL]...
MrExcel: [URL]....

View 1 Replies View Related

Tick/show The Check Mark On The Checkbox

Mar 18, 2009

I received a spreadsheet form containing some checkboxes that I need to tick. The problem is I dont know how can I tick/show the check mark on the checkbox. everytime I double click it, macro vb screen appears.

View 4 Replies View Related

Select/Tick/Check A Checkbox Via Vba Code

Oct 1, 2006

How do i check a checkbox on an excel worksheet?

View 5 Replies View Related

VBA Square Option Buttons With Check Marks?

Feb 4, 2014

I try to make option buttons instead of round with a black dot but square box with check mark liked the check box. Box can be filled with color (light blue or other color). When the box is picked the fill change to white background.

I have 5 option boxs, I like to group them in one group because I have other groups using the option boxs. I want the check mak stayed in that group when it is picked.

View 14 Replies View Related

Can't Get Tick Boxes To Effect Pie Chart

Apr 28, 2014

I have set up a spread sheet which uses tick boxes and I have calculated it all up so that the percentage of ticks ticked is displayed in a cell etc. and when I link that data to a bar chart it works perfectly. .e.g as I tick the boxes the bar chart increases

BUT when I try to do the exact same thing with a pie chart it doesn't work.

View 14 Replies View Related

Position Of Tick In Column Chart?

Jan 9, 2014

I have 6 column charts that are supposed to be identical. There are 12 pair of columns per chart. Some chart's pair are centered over the tick and some pair are to the right of the tick and I can't figure out how to make them all the same.

View 1 Replies View Related

X & Y Scale Chart Max,min,tick Linked To Cell Values

Dec 10, 2008

I am using Jon Peltier's worksheet_change event code to try and automate chart axes.

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$AG$5"
ActiveSheet.ChartObjects("Chart 2").Chart.Axes(xlCategory) _
.MaximumScale = Target.Value
Case "$B$3"
ActiveSheet.ChartObjects("Chart 2").Chart.Axes(xlCategory) _
.MinimumScale = Target.Value
Case "$AG$7"
ActiveSheet.ChartObjects("Chart 2").Chart.Axes(xlCategory) _
.MajorUnit = Target.Value
Case "$L$3"
ActiveSheet.ChartObjects("Chart 2").Chart.Axes(xlValue) _
.MaximumScale = Target.Value
Case "$N$3"
ActiveSheet.ChartObjects("Chart 2").Chart.Axes(xlValue) _
.MinimumScale = Target.Value
Case "$AH$7"
ActiveSheet.ChartObjects("Chart 2").Chart.Axes(xlValue) _
.MajorUnit = Target.Value
Case Else
End Select
End Sub

However, I have some of the cells setup as formulas....but worksheet_change apparently only updates values when manually changed.

View 9 Replies View Related

Position Chart/Graph Tick Mark Labels

May 21, 2008

how to put the categories (Column H) out of the graph? (so more to the left, so not in the grey background) Here in the attachment you will see that the titles are in the graph instead of outside the grey background. Is it possible to do that?

View 2 Replies View Related

Gantt-type Chart With Quarterly Marks On The Date Axis?

May 22, 2014

I'm using a stacked bar chart (in Excel 2010, running on Windows 7) to create a simple Gantt-type chart - with just four or five bars. I've got my chart looking most of the way I want it to, but one thing still eludes me: I'd like to set up the major axis ticks to be quarters of the year (from 1/1/2011 to 4/1/2013). Since quarters are not regular intervals (they are not exactly every 90 days), I can't do this using Excel's standard functionality for choosing axis tick marks.

View 3 Replies View Related

Restrict Tick Cell Upon Selection To 1 Tick Per Row

Jan 10, 2007

I was reading your Tick Cell Upon Selection article and it works great. I'm just wondering if there is a way to modify it so that they can only select one of the cells in a row.

For example, in this spreadsheet, the cells I have marked for "tick upon selection" are N8-Q8. In this worksheet, though, I only want the user to be able to select one of the four options. Is there a way to format the code so that they either cannot select another cell until they have deselected the first one, or the first one unchecks itself and the new click ticks that cell?

Example: Person selects N8. Person then selects P8. Can it not allow P8 to be selected (and give a warning message) or can it uncheck N8 when P8 is checked?

View 6 Replies View Related

Chart Won't Plot Dates

Dec 6, 2006

I have some weekly data that I need to produce a graph from (100% Stacked Column). Each time I create the graph using the dates as the x axis i only get a thin line which looks like it represents one day, the other space looks like it is for the other 6 days of the week. I know that you could add an apostrophe to the beginning of the date but this is to be an automated report.

View 9 Replies View Related

Not Plot Blanks In Chart

Oct 8, 2007

I have a set of data which indicates readings taken at different dates/times at varying intervals.

I want to create a chart where time is the X-axis but the usual charting feature would spread the data points at regular intervals. I want the data is spread out across the X-axis according to the actual timings.

I have a sample data in the file attached to this posting. There I showed the type of chart I want to see (which I achieved only by modifying the original set, Table 1. The modified set of data is in Table 2)

how to achieve this with the original table of data, Table 1.

View 9 Replies View Related

Plot By Region Chart

Jan 1, 2008

I am trying to figure out the best way to plot this data -- For each region, I want to plot December 2006 snowfall against December 2007 snowfall. So starting on row 12 to row 41 (in the attached file). First challenge: the dates are not aligned because it is using the retail calendar where 12/3/2006 is compared against 12/2/2007. How can I plot the snow depth for the Northeast for example? I can't just use a dual axis chart because there are also dual dates...

View 3 Replies View Related

How To Plot 2 Chart Types On One Graph In VBA

Apr 14, 2014

I would like to create a chart in vba which contains 2 sets of data, both using the same x axis. The first must be a line graph, the second a staggered bar chart. This must be represented on one chart with data labels. Also, how do I change the colour of the plots?

View 5 Replies View Related

Chart: Plot High And Low Data Only

Aug 12, 2008

I have a 46000 rows of data. I want to make a chart, but only want to plot the highest and lowest data points in the data set. How do I get Excel to automatically find and plot only the highest and lowest data points?

View 9 Replies View Related

Don't Plot Blank Cells In Bar Chart

Mar 17, 2006

I am trying to set up a bar chart that will not plot values where I have left the cell blank so that I don't have to keep resizing the source data / sorting the data whenever I add more data.

I have tried putting NA() as the value as you would for scatter plots
I have also tried leaving the category cell blank

Neither of these seem to work. I have attached an example.

View 9 Replies View Related

Not Plot Zero Values On Chart/Graph

Oct 20, 2006

one of my excel reports, i am using a dsum formula and plotting a chart against it. i do not want to show the zeros on the graph, is there anyway i can do that, i could not find anything in the tools -> options.

View 2 Replies View Related

Chart/Plot Changing Range

Oct 24, 2006

I have a chart updating on a weekly basis

a) can i select a whole range without the chart picking up any blank cells or zeros, if so then a lot of my other question will be redundant

b) I only want to show 4 weeks at a time, so when a new column of data is added on, how do i get VBA to shift the range accross 1 to the right e.g.

week 36 37 38 39
Shift to
week 37 38 39 40

View 5 Replies View Related

Plot Chart From Selected Data

Nov 9, 2006

I have a large amount of data recorded from a logging device which i then need to convert to a graph. Is there some nice coding to enable the user to select a range of dates from column A and times from column B then allow the user to select the column in which relevant data is contained and plot a line graph of the data contained with named axes.

View 9 Replies View Related

Plot Columns With Chart Macro

Jul 11, 2007

I have 2 columns og data, for example

120
120
120
120
220
220
220
220
320
320
320
320
420
420
420
420

I want to plot them via a chart. But here is the problem..
My code.....................

View 3 Replies View Related

Plot Chart With Dynamic Range

Jun 27, 2008

I maintain data which gets updated every week. I have a chart associated with this data which I want to get updated automatically. I tried to use dynamic range on the chart and it kinda works. But the issue with my data is that I have data set in a row, followed by a blank cell which is then followed by average of last two weeks. Hence, when I use a dynamic range, it also displays the last value in the row (average), which I don't want to display in my chart.

So what I am looking forward to do is set up dynamic range or any other solution, which automatically updates my chart with weekly sales data without showing the average value in the chart. I have attached sample worksheet here.

View 4 Replies View Related

Plot Horizontal Line ALL Way Across Column Chart?

Apr 10, 2014

I have a data series plotted as columns. Then I want a horizontal line at $5,000 to appear all the way across the chart. It appears from the 1st to the last data point, but there is blank space before the first point and after the last point. I would like the red line to extend into this blank space before and after, so that it is going across the entire chart.

I tried playing around with different axis settings and no luck.

View 2 Replies View Related

Format Chart Plot Series/Axis

Jan 16, 2007

im having problem formatting my graph.

chart type = line.

I have 1 series of data, which is N values vs. Time.

Time however, is specified by specific dates. The graph is not putting a plot point accorrding to the date corresponding to the N value.

Example values:

date:____1/1/05 _______ 5/7/05 _____ 8/13/05
n value: __55 ___________ 22 _________ 11

I want the chart to reflect the time between the dates and put a plot point (n value) under each date listed and connect with a line.

View 9 Replies View Related

Plot Multiple Series In 1 Graph/Chart

Aug 18, 2006

how can i plot multiple series of values in one graph after checking some check boxes, which i have previously done, randomly?

View 4 Replies View Related

Not Plot Empty/Blank Cell In Chart

Aug 21, 2006

For Excel 2000:

In worksheet A, there is a column of numbers that can be 0 or not zero.

In worksheet B, there is a column of cells that determines if a corresponding cell in worksheet A is zero or not.


'As an example, for cell 'B!C6
=If( 'A!B52=0,"",'A!B52)

The column in worksheet B is used in a chart.

The chart settings are:
Tools | Options | Chart | Active Chart- Plot empty cells as: Not plotted

The chart is not treating "" as EMPTY, and therefore is not presenting correctly.

How would I set the value of cell 'B!C6 to EMPTY (or null, or blank, or whatever Excel calls it) using an IF statement, such that 'B!C6 would evaluate to EMPTY, and be ignored by the chart?

Would this be any different in Excel 2003?

View 9 Replies View Related

Incorrect Plot Order: Area Chart

Oct 26, 2006

I have plenty of experience with VBA outside of charts so that's where I need assistance. I need to get SeriesCollection(4), the PTAI series, to appear on the area chart second from the bottom instead of on the top.

The order for the non-line series should be, from top to bottom:
SeriesCollection(3) - Non-Mission AC ( Training, T&E, AMarc series)
SeriesCollection(2) - Total Pipeline series
SeriesCollection(4) - PTAI series
SeriesCollection(1) - Available PMAI series

Here's the

Sub MakeSandChart()

Dim ChartSource As Range
Dim ChartName As String
Dim ChartSheet As String
Dim yCount As Integer
Dim PAA_Value As Integer

Application. ScreenUpdating = False

passtype = Mid(ActiveSheet.Name, 5, 1)
Set ws = Worksheets(ActiveSheet.Name)

ChartName = Left(ActiveSheet.Name, 5)
ChartSheet = ChartName & " Chart"
ChartName = "F18" & passtype
Set ChartSource = Union(Range("SummRowDate" & passtype), _
Range("SummRowTAI" & passtype), _
Range("SummRowNM" & passtype), _
Range("SummRowTotPipe" & passtype), _
Range("SummRowPTAI" & passtype), _
Range("SummRowPMAI" & passtype), _
Range("SummRowPlanPAA" & passtype), _
Range("SummRowWorkPAA" & passtype), _
Range("SummRowDrillPAA" & passtype), _
Range("SummRowBaseline" & passtype))

Worksheets(ChartSheet).Activate

View 9 Replies View Related

Chart: Plot Overlapping Values Software

Dec 8, 2006

I wanted to ask if you know any charting software which can give weight to elements on a chart when two or more variables overlap? Ideally the color intensity of, say, circles should increase from pale blue to vivid blue depending on the number of the data items which are operlapping at one point. I include a sample chart which should give you a general idea of the chart I want to make and the data set from which it was made.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved